"edvwvw via OfficeKB.com" <u42512@uwe wrote in message
news:846e7c6580db0@uwe...
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

=IF(M2=0,0,....IF(M2<810,"LOW Rating",SUM(M2))))))

My interpretation is:

If M2 = 0 then 0
If M2 0 and <8 then M2

You're missing that test and a cell reference can't be used in an array
constant.

The easiest way to do this is to create a 2 column table:

...........A..........B..........
1........0..........=M2
2........8.........LOW Rating
3.......10........MEDIUM Rating
4.......12........WARNING High Rating
5.......16........STOP You have reached EXTREME

Then:

=IF(M2="","",VLOOKUP(M2,A1:B5,2)

--
Biff
Microsoft Excel MVP