Use a lookup table something like this. In Cells A1:B10 add the following:
Score Description
999 Superior
91 High
75 Average
25 Low Average
10 Mildly Impared - Low Normal
8 Mildly Impared
6 Mild to Moderately Impared
5 Moderately Impared
1 Severly Impared

Now in Cell E1 Add the formula
=INDEX($B$2:$B$10,MATCH(D1,$A$2:$A$10,-1))
Put your score in cell D1 and the correponding rating will be desplayed by
the formula.

Here is another reference on the 7 nested funcitons limit...
http://www.cpearson.com/excel/nested.htm
--
HTH...

Jim Thomlinson


"Shek5150" wrote:

I'm trying to enter the following forumula:

=IF(G5="","",IF(I591,"Superior",IF(I575,"High
Average",IF(I525,"Average",IF(I510,"Low Average",IF(I58,"Mildly
Impaired-Low Normal", IF(I56,"Mildly Impaired", IF(I5=5,"Mild to Moderately
Impaired",IF(I51,"Moderately Impaired","Severely Impaired")))))))))

However, MS Excel is not permitting it...and the only thing I seem to be
able to find in the help is "Nest No More Than Seven Functions."

Can someone tell me if this is why Excel won't accept my formula? If so, is
there a way around this...[[just for the record, it gets hung up on
"IF(I51,"Moderately Impaired","Severely Impaired")))))))))]]

Thanks, in advance for any help.

Steve