IF rule with 4 possible outcomes

Hi All,

Have been relying on this forum for a long time to answer excel related prayers...need to make a post to get the answer to this one though!

I am using an IF to give me one of four possible outcomes based on ranges I have:

A1<12 = "STRONG"
11<A1<35 = "SATISFACTORY"
34<A1<112 = "NEEDS IMPROVEMENT"
111<A1 ="WEAK"

I have a similar formula I use for 3 outcomes (below), but cant seem to get the fourth IF rule to nest.
=IF(AND(A1>=59),"HIGH",IF(OR(A1<=9),"LOW","MEDIUM"))

I think it should be something like the below but excel says there is too many arguments, and cant help fix it.
IF(AND(A1<12),"STRONG",AND(IF(OR(11<A1<35),”SATISFACTORY”)),IF(OR(34<A1<112),”NEEDS IMPROVEMENT”)),"WEAK")

Any help would be much appreciated!

Cheers, Alex

How about:

Please Login or Register  to view this content.

Pepe's LOOKUP worked perfectly- appreciate your quick response!

Originally Posted by Pepe Le Mokko

Perhaps

Please Login or Register  to view this content.