| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF STATEMENT
Not sure about your ranges, but....
Try this: =LOOKUP(A1*100,{0,1,2,3},{0,50,100,150}) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "TRYIN" wrote in message ... I NEED HELP WITH THE FOLLOWING IF STATEMENT: IF A1 IS BETWEEN 1% AND 1.9% =50 IF A1 IS BETWEEN 2% AND 2.9% =100 IF A1 IS 4% OR MORE =150 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| If Then Statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
