| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Thanks very much for your help, works great.
"Niek Otten" wrote: Hi Kevin, You don't tell what it has to be if A1<0, what if it is 3.5, etc, but this may help: =IF(A1<4,"low",IF(A1<7,"medium",IF(A1<11,"high","e xtreme"))) -- Kind Regards, Niek Otten Microsoft MVP - Excel "kevin" wrote in message ... I hope someone might be able to show me how to express the following in an IF statement. =if(a1 is between 0 and 3 then "low", if(a1 is between 4 and 6 then "medium", if(a1 is between 7 and 10 then "high", if(a110 then "extreme", "") -- Thanks Kevin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
| Statement | Excel Worksheet Functions | |||
| Duplicate fields does not match up! If statement | Excel Worksheet Functions | |||
| IF Statement difficulty | Excel Worksheet Functions | |||
Threaded Mode
