IF Command Help  
Author Message
GregWetzel





PostPosted: Mon Sep 17 14:27:15 PDT 2007 Top

worksheet functions >> 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)

Excel305  
 
 
Don





PostPosted: Mon Sep 17 14:27:15 PDT 2007 Top

worksheet functions >> 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



>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)