Nesting functions

[David Rose]

How many functions can be nested together? Currently, my
function looks like this:

=IF('Dec 11'!I33 ="P",'Dec 11'!$O$1,IF('Dec 18'!
I33="P",'Dec 18'!$O$1,IF('Jan 7'!I33="P",'Jan 7'!$O$1,IF
('Jan 14'!I33="P",'Jan 14'!$O$1,IF('Jan 21'!I33="P",'Jan
21'!$O$1,IF('Jan 28'!I33="P",'Jan 28'!$O$1,""))))))

which references worksheets in my workbook. ($O$1 contains
a date)

How many more worksheets can I insert into this work book,
changing the above formula as required, and still have it
work properly?

Thanks

 

[Frank Kabel]

Hi David
7 is the maximum. I'm not sure what you are trying to achieve with this
function but normaly I would replace multiple IF functions with a
lookup table together with VLOOKUP. If referencing other sheets this
can combined with INDIRECT.


HTH
Frank