IF function question

[fred]

I know MS Excel 2003 has a limited =If(this,then this,or else) sequence in one cell.


Is there also a limitation on the number of layers of "if" in MS Excel 2007?


Frederick

 

[Luke M]

Yes, 64 levels (wow!)

Note that's it's not just "IF"'s that are limited, it's the number of functions that you can nest within each other.


Reference:

http://office.microsoft.com/en-us/excel-help/office-excel-2007-features-that-are-not-supported-in-earlier-versions-of-excel-HA010077823.aspx

 

[oldchippy]

Hi,


You could try nested IF's http://www.cpearson.com/excel/nested.htm

 

[fred]

Danke, danke!

 

[Hui]

If you are really looking at using more than a handful of nested If's I would recomend you think about alternative ways of defining and tackling your problem.


There is nothing wrong with using complex If's it is just that getting them correct and maintenance of them is so much more difficult.


Options like Choose or writing a UDF may be a simpler method.

Instead of using If's to find the positive, can you use less if's to find the negatives.