View Single Post
  #1   Report Post  
mwc0914
 
Posts: n/a
Default nested IF maximum?


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.


--
mwc0914
------------------------------------------------------------------------
mwc0914's Profile: http://www.excelforum.com/member.php...o&userid=24130
View this thread: http://www.excelforum.com/showthread...hreadid=379319