nested IF maximum?

  • Thread starter Thread starter mwc0914
  • Start date Start date
M

mwc0914

Is there a limit to how many nested IFs can be contained in a singl
formula?

I am working with a golf application and I want to set a value if th
results of the first hole are not equal. If they are equal, then chec
the second hole, etc. This would mean I need 18 IFs in a singl
formula
 
the limit is 7 I beleive but there are likely ways aroundit if yo
describe what you want to do a little mor
 
The maximum is 7, but if you are near that enough, you better start thinking
of another solution to the problem, as you formula will become unreadable.

Explain the scenario to see what is the best solution.
 
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

nested IF without repeating the condition? 1
A better way than nested IF? 3
Arrayformulas with either/or nested to sumproduct if eitherconditions are true 13
Nest IF function 6
CountIf previous cell formula 0
Nesting of more than 7 in an IF formula 8
IF function says too many nested 1
Conditional Format 1

Back
Top