You're correct, you can't nest more than 7 functions. First workaround is to
split the route of logic about halfway (say the 8 condition), as in:
=IF(G5="","",IF(I58,IF(I591,"Superior",IF(I575, "High
Average",IF(I525,"Average",IF(I510,"Low Average","Mildly Imparied-Low
Normal")))),IF(I56,"Mildly Impaired", IF(I5=5,"Mild to Moderately
Impaired",IF(I51,"Moderately Impaired","Severely Impaired"))))

Note that formula now has 6 nested functions 1 route, 5 the other route.

ALternative, if you don't mind using space, would be to create a lookup
table. You'd need to play around with integers vs. decimals, but it would
make your formula easier.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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