IF Command Help

[Guest]

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)

 

[Don Guillett]

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