HOW MANY IF STATEMENTS CAN YOU HAVE IN ONE FORMULA?

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

Guest

I have nine conditions I want the IF statement to recognize, but when I enter
the formula I get an error after the 8th condition.
Any help would be greatly appreciated.
 
You can only use 7 nested IF. There are other options, like CHOOSE, VLOOKUP
or MATCH/INDEX that may fit in your particular case, check the help for those
functions as that may give you ideas.

Hope this helps,
Miguel.
 
You can actually have quite a few. While you can only have 7 nested if
statements, you can format you equation to unnest the ifs in most occurances
for example
=if(a1>2,5,if(a1>0,3,1) has two levels of ifs

while
=if(a1>2,5,0)+if(and(A1>0,A1<=2),3,0) and if(A1<=0,1,0)
will give the same answer with one level of if staements.

There are multiple other equations which will give the same answer, but will
not be hit by the 7 nested limit.
 

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

Nested If 3
conditions in if statements 1
How many if's? 4
Conditional If Statements 4
IF statement Help 10
IF statement syntax 4
Conditional Formatting Applied when Statement Not True 6
If statement and colors 17

Back
Top