Excel 2003 and earlier versions are limited to 7 levels of nested functions.
Excel 2007 increases the limit to 64.

You could use a LOOKUP function instead:

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

HTH
Elkar


"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