IF/OR Nested IF/OR. Help please

[James8761]

Hi,

I’ve been struggling to put a formula in to Excel. For instance in Cell L4 I want to say the below. Cell L4 = -26% so I want the cell to say Poor. Cell L5 = 15% so I want it to say OK etc.
Any help greatly appreciated.

If the accuracy is between 0% and 5% or between 0% and -5% then “Good”
If the accuracy is between 6% and 10% or between -6% and -10% then “Average”
If the accuracy is between 11% and 20% or between -11% and -20% then “OK”
If the accuracy is greater than 20% or less than -20% then “Poor”

Thanks

 

[ukmikeb]

Try :-

=LOOKUP(ABS(L4),{0,0.06,0.11,0.20},{"Good","Average","Ok","Poor"})

hth

 

[James8761]

Try :-

=LOOKUP(ABS(L4),{0,0.06,0.11,0.20},{"Good","Average","Ok","Poor"})

hth

That's great, thanks very much. Will take my head off the desk now.