EXCEL (IF)
in [General]
|
Prev: excel versions
Next: CONDITIONAL FORMATTING- EXCEL
From: Alicia-Paris on 12 May 2010 07:31 THANKS, BUT DIDNT WRK NEITHER :( "Jacob Skaria" wrote: > Try > > =IF(E1,CHOOSE(E1,12,57,67,77,87),"") > > -- > Jacob (MVP - Excel) > > > "Alicia-Paris" wrote: > > > COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on > > COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to > > depend on the E COLUMN. But I am not sure how to do this. > > > > The IF function doesnt work because I want there to be 5 conditions. > > > > Basically.... 1= one number 2= a different number 3= a diff number and so > > on; and with this, depending on which number gets put in cell E (1-5), i want > > F to reflect the true number. > > > > Please help guys as this is driving me bonkers!
From: Jacob Skaria on 12 May 2010 07:36 Mike has mentioned which function to be used. Check out help on CHOOSE() and modify the values to suit. Incase the cell in E1 do not have a value; the formula will return an error., You can handle that using the IF() statement mentioned in the previous formula.... -- Jacob (MVP - Excel) "Alicia-Paris" wrote: > THANKS, BUT DIDNT WRK NEITHER :( > > "Jacob Skaria" wrote: > > > Try > > > > =IF(E1,CHOOSE(E1,12,57,67,77,87),"") > > > > -- > > Jacob (MVP - Excel) > > > > > > "Alicia-Paris" wrote: > > > > > COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on > > > COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to > > > depend on the E COLUMN. But I am not sure how to do this. > > > > > > The IF function doesnt work because I want there to be 5 conditions. > > > > > > Basically.... 1= one number 2= a different number 3= a diff number and so > > > on; and with this, depending on which number gets put in cell E (1-5), i want > > > F to reflect the true number. > > > > > > Please help guys as this is driving me bonkers!
From: Reg on 12 May 2010 08:41
unless i miss something important Column F is always 36 x column E so in your example: put "=36*E3" in F3 and copy down If you got the example wrong (the text says 'true value between 1-5') then the formula might be "=36/E3" hth RegMigrant "Alicia-Paris" wrote: > It didnt work. > > Basically: 1=36, 2=72, 3=108, 4=132, 5=165. > > COLUMN E comes from a different worksheet via macros, so i want COLUMN F to > then show the true value between 1-5 to the numbers shown above. > > i.e. > > e3= 4............... therefore i want f3= 132 > > "Mike H" wrote: > > > Hi, > > > > This isn't; to me, very clear but maybe this > > > > =CHOOSE(E1,12,57,67,77,87) > > > > Now if e1 is 1 the formula returns 12, If e1=2 it returns 57 etc > > -- > > Mike > > > > When competing hypotheses are otherwise equal, adopt the hypothesis that > > introduces the fewest assumptions while still sufficiently answering the > > question. > > > > > > "Alicia-Paris" wrote: > > > > > COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on > > > COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to > > > depend on the E COLUMN. But I am not sure how to do this. > > > > > > The IF function doesnt work because I want there to be 5 conditions. > > > > > > Basically.... 1= one number 2= a different number 3= a diff number and so > > > on; and with this, depending on which number gets put in cell E (1-5), i want > > > F to reflect the true number. > > > > > > Please help guys as this is driving me bonkers! |