| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If then statement
Col A Col B
0 M01 243.8 M01 243.9 M02 312 M02 313 M03 381 M03 382 M04 450 M04 451 M05 520 M05 In Cell D1 type =Lookup(C1,A1:B10) The table acts as ranges for your M0 numbers. The lookup find the actual that you input into C1 say 427, and the corresponding M0 number is retruned, in this case it would be M04 Thanks Matt Anna McKenzie wrote: I would like to set up an if then statement incorporating the language below: If AK11 is <= 243.9 then it is grade M01 If AK11 is =244 but less than 313 then M02 If AK11 is =313 but less than 382 then M03 If AK11 is =382 but less than 451 then M04 If AK11 is =451 but less than 520 then M05 Is this possible. Pls advise. EggHeadCafe - Software Developer Portal of Choice XCeed Streaming Compression Library http://www.eggheadcafe.com/tutorials...compressi.aspx -- Matt Lynn Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Hybrid Mode
