nested IF maximum?

[mwc0914]

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

I am working with a golf application and I want to set a value if the results of the first hole are not equal. If they are equal, then check the second hole, etc. This would mean I need 18 IFs in a single formula.

[duane]

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

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

--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp

[mwc0914]

Thanks...I figured a way around it

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

--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp

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

--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp

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

--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp

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

--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp

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

--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp

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

--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp

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

--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp

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

--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp

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

--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp