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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nest vs Hive? 10
Bargain Nest Mini (2nd Gen) - Chalk 0
Nest Guard has hidden microphone 2
solving nested IF statements 13
NESTED OR FORMULAS 5
If Statement Nesting? 4
Randbetween function 12
Nested IF 4

Back
Top