The 7-function limit is true for all nested functions in versions
prior to 2007. What are the actual if conditions? There are several
techniques to circumvent this limitations, with nested IFs.


On Aug 20, 1:18 pm, Ron Rosenfeld wrote:
On Mon, 20 Aug 2007 10:14:01 -0700, Dave
wrote:

I am trying to string together IF functions to fulfill my requirements.
However if i need more than 7 conditions (from my understanding the nested IF
functions only go up to 7 cases) is there an alternative to this that would
give me the same results? Thanks

Yes there is.
--ron