There are usually alternative ways of writing formulae to avoid
excessive nesting of IFs. Post your formula here with a description of
what you are trying to do and someone will be able to advise on other
ways of achieving the desired outcomes.

Hope this helps.

Pete

On May 12, 11:22 pm, Hal mcl wrote:
I am trying to use a formula with 13 nested IFs in Excel 2007. But I get a
message that the formula "uses more levels of nesting than are allowed in the
current format" whether I am using xlsx, xlsm or xlsb. Excel 2007 is supposed
to allow up to 64 nestings but I find it balks at more than seven.
--
Hal