T. Valko wrote:
P.S.

IF(M2<810

I'm not sure how to interpret that so I guessed.

I'm guessing this is what you had in mind:

[quoted text clipped - 11 lines]
High Rating",IF(M2<1210,"MEDIUM Rating",IF(M2<810,"LOW
Rating",SUM(M2))))))


Try this formula

=LOOKUP(M2,{0,10,12,16;"LOW RATING","MEDIUM RATING","HIGH RATING","You have
reached EXTREME"})

It will should give the desired result and is easier to read/change

edvwvw

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200805/1