Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nest no more than seven functions???
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too many functions to nest? | Excel Discussion (Misc queries) | |||
Is it possible to nest more than 7 functions | Excel Discussion (Misc queries) | |||
help with functions to nest | Excel Worksheet Functions | |||
how do I nest functions | Excel Worksheet Functions | |||
How do I nest these 3 IF functions? | Excel Worksheet Functions |