WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUMULA

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

Guest

as above, what is the max number of "if" conditions available in one formula?
i cannot seem to add more than 8??
 
Actually, there is no real limit on the number of IF functions in a single
formula. The limit is on the levels of nesting. Functions can be nested up
to 7 levels deep in a formula.

For example, the following formula far exceeds 8 IFs in a single formula,
but still adheres to the limit of 7 levels of nesting.

=IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"D",IF(A1=5,"E",IF(A1=6,"F",IF(A1=7,"G",IF(A1=8,"H",""))))))))&IF(A1=9,"I",IF(A1=10,"J",IF(A1=11,"K",IF(A1=12,"L",IF(A1=13,"M",IF(A1=14,"N",IF(A1=15,"O",IF(A1=16,"P",""))))))))

HTH,
Elkar
 
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
Reference the 2nd and 3rd highest in range. 2
Changing entire row based on 1 MAX cell value (Conditional Formatt 2
Conditional formatting based on max in range of other columns 2
Applying Conditional Formatting to a Max number in range 5
Sumif to multiple tabs 1
One less than Max 1
When there is a tie for "MAX" values... 6

Back
Top