IF Command Help
 

I am useing office 2007. I would like to take info from a cell and use the if
command to change it around . In the cell it can have three numbers but all
three numbers need different outputs. exsample is
Cell Output
22 1.3
24 1.05
26 .85
so if the cell has 22 in it I would like to output 1.3 if it has 24 I would
like to output 1.05 and so on. I have tried differnt ways of using
=IF(G8=22,1.3,.85)

IF Command Help
 

You can do this with
nested ifs =if(g8=22,1.3,if(g8=24,1.05,if(g8=26,.85,"")))
or look in the help index for
LOOKUP
CHOOSE

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Teknomek" wrote in message
...
I am useing office 2007. I would like to take info from a cell and use the
if
command to change it around . In the cell it can have three numbers but
all
three numbers need different outputs. exsample is
Cell Output
22 1.3
24 1.05
26 .85
so if the cell has 22 in it I would like to output 1.3 if it has 24 I
would
like to output 1.05 and so on. I have tried differnt ways of using
=IF(G8=22,1.3,.85)