Nested IF statements ...

  • Thread starter Thread starter Andy Davis
  • Start date Start date
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?
 
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.
 
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.
 
Back
Top