nested formula help needed

[donkey26]

This is what the help menu tells me.

"Nest no more than seven functions You can enter, or nest, no more than
seven levels of functions within a function. Learn about creating
nested functions."

I was curious if anyone could tell me how to write a IF statement with
more than seven functions? Is it even possible? Is there a way to
combine functions to give the same effect? I am trying to write one
with approximately 25. Any help would be greatly appreciated. I have
tried just about everything and am very stumped.

Thanks.

 

[Peo Sjoblom]

Please don't multipost, see possible answer in the misc NG

 

[Guest]

My experience is Yes, you are limited to seven nested
functions.
But my question is, do the functions really need to be
nested? I ask this because I received the same message
recently and found that in my case I was nesting the
functions when I didn't need to. Once I built the
statement correctly without nesting I put in well over 20
calculations in the one cell.

One way I overcame the seven nested function rule was to
build multiple cells each doing seven nested functions.
The final cell then used the results of the others