| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.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) |
|
#2
Posted to microsoft.public.excel.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 "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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help Command | Excel Discussion (Misc queries) | |||
| Command T-ONE | Excel Discussion (Misc queries) | |||
| can I use IF as a GO TO command? | Excel Worksheet Functions | |||
| if command for yes or no | Excel Worksheet Functions | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Hybrid Mode
