Steve,

Here is one of the many ways around the 7 nest limitation:

=IF(G5="","",LOOKUP(I5,{1,5,6,8,10,25,75,91},{"Sev erely Impaired","Mild to Moderately
Impaired","Mildly Impaired","Mildly Impaired-Low Normal","Low Average","Average","High
Average","Superior"}))

Here is another:

=IF(G5="","",VLOOKUP(I5,$A$1:$B$8,2))
Where A1 to A8 has 1,5,6,8,10,25,75,91
and B1 to B8 has "Severely Impaired","Mild to Moderately Impaired","Mildly Impaired","Mildly
Impaired-Low Normal","Low Average","Average","High Average","Superior"


HTH,
Bernie
MS Excel MVP


"Shek5150" wrote in message
...
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