nested IF maximum?

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
 
D

duane

the limit is 7 I beleive but there are likely ways aroundit if yo
describe what you want to do a little mor
 
C

cmart02

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.
 
Top