 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2007IF 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) 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  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >I am useing office 2007. I would like to take info from a cell and use the >if [quoted text clipped - 9 lines] > like to output 1.05 and so on. I have tried differnt ways of using > =IF(G8=22,1.3,.85) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.