 |
 | 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 / June 2006IF STATEMENT
This is what I'm trying to do... IF A2 IS EQUAL TO 8 THEN DISPLAY 228.0 IN A3 A2 IS EQUAL TO 10 THEN DISPLAY 182.4 IN A3 A2 IS EQUAL TO 12 THEN DISPLAY 152.0 IN A3 A2 IS EQUAL TO 16 THEN DISPLAY 114.0 IN A3 A2 IS EQUAL TO 20 THEN DISPLAY 91.2 IN A3 A2 IS EQUAL TO 24 THEN DISPLAY 76.0 IN A3 Could someone show me easiest way to do this? Much appreciated... Hi =IF(A2=8,228,IF(A2=10,182.4,IF(A2=12,152,IF(A2=16,114,IF(A2=20,91.2,IF(A2=24,76,FALSE)))))) HTH regards from Brazil Marcelo > This is what I'm trying to do... > [quoted text clipped - 8 lines] > Could someone show me easiest way to do this? > Much appreciated... THANKS! > Hi > [quoted text clipped - 16 lines] > > Could someone show me easiest way to do this? > > Much appreciated... thanks for the feedback > THANKS! > [quoted text clipped - 18 lines] > > > Could someone show me easiest way to do this? > > > Much appreciated... You can: 1) Use vlookup 2) Use if: =IF(A2=8,228,IF(A2=10,182.4,IF(A2=12,152,IF(A2=16,114,IF(A2=20,91.2,IF(A2=24,76,"Out of Range")))))) 3) Use lookup: =LOOKUP(A2, {8,10,12,16,20,24;228,182.4,152,114,91.2,76})  SignatureBearacade |
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.