Max number of IF statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the max number of If statements you can use in a formula ?
Thanks,
yosef
 
You can have dozens of IF() statements, but they can only be nested 7
deep. For a workaround, see

http://cpearson.com/excel/nested.htm

OTOH, if you have to nest more than 4 or 5 deep, it's almost always
easier to use an alternative method, e.g., Lookups, math operations, etc.
 
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

Conditional Format based upon if statement and max 11
Max amount of "IF" statements 2
Max with Multiple Ifs 3
Conditional Formatting 2
Too Many Nested IF Statements! 5
One less than Max 1
MAX Function Issue 2
Finding location (or start cell) of highest consecutive values 3

Back
Top