nested formula help needed

  • Thread starter Thread starter donkey26
  • Start date Start date
D

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.
 
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
 
Back
Top