I am having difficulties with the parentheses in my nested if statement. I need to display one of either 4 text based on values, example Low (between 0 and 7), Medium (8-10), High (11-13) and Very High (14-16).

Help appreciated

RR

Hi, If cell A1 contains the value being tested, this set of nested IF's returns your required texts.

The formula first tests for values outside your specified ranges (below 0 or above 16) and returns a blank cell.

=IF(OR(A1<0,A1>16),"",IF(A1<8,"low",IF(A1<11,"medium",IF(A1<14,"high","very high"))))

Regards

Brilliant, works like a charm. Many thanks. RR

You're welcome. Thanks for letting us know it works.

Regards

Humar

Ask Your Question

Weekly Poll