EXCEL (IF)
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!
|