Excel 2007 balks at >7 nested IFs

[Hal mcl]

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.

 

[Pete_UK]

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

 

[T. Valko]

the formula "uses more levels of nesting than are allowed in the

current format"

Did you open a file in xls format in Excel 2007?

Biff

 

[Hal mcl]

Thank you very much fo your help. The file was originally xls. Saving it as
xlsx evidently did not remove the limitations on xls. I have now copied the
file into a new 2007 Workbook and my formula with 13 IF nestings (for which
no series of VLOOKUPs can substitute) works like charm!

 

[Shmem]

I know this comment is old but I'm stumped. I've sort of self-taught myself
how to use Excel for work, and I'm trying to use an IF statement with 15
nested IFs. I cannot save it as xlsx because the document needs to be in a
format accessible to people with older computers. Is there a way I can get
around this by using another type of statement?

Thanks so much. I appreciate any help. If someone thinks they can I'd be
happy to send them the actual formula I am working on.

Em

 

[T. Valko]

See this:

http://spreadsheetpage.com/index.php/tip/alternatives_to_nested_if_functions/