Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to express this in an if statement.
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 |