Nested IF statements ...

A

Andy Davis

What is the maximum number of nested IFs Excel can
handle? Is the limiting factors the number of characters
a cell can accommodate or is it the number of nested IFs?
 
J

J.E. McGimpsey

Seven functions may be nested - it's a limitation of the nesting,
not the characters.

In my experience, whenever nesting gets deeper than about 4, perhaps
5 levels, there's an easier way to solve the problem using
mathematical relationships or lookup tables. Deep nesting is the
hardest type of formula to maintain, especially if it's not just for
your use.
 
A

Andy B

Andy

I believe the maximum number of nested IFs is 7. There are usually ways
aroud this by rewriting the formula a different way

Andy.
 
Top