Just FYI - in 2007:
Nested levels of functions limit is 64
Length of formula contents limit is 8,192 characters
Others:
http://office.microsoft.com/en-us/ex...738491033.aspx

"nhebb" wrote:

Every diagram is going to be different, of course, depending on the
logic of the statements. If I get a really hairy one that I have
trouble getting the syntax right, then I create each "piece" of the
statement in separate cells. Then I go through and build up the final
statement from the inside out, using the formulas from each of the
cells. I hope that doesn't sound too confusing.

I think someone makes an Excel add-in for creating complex nested
IF's. You could always search around for it.

Also, there is a limit to the nesting. You can only go 7 nests deep.
Chip Pearson has an article showing how to work around this:
http://www.cpearson.com/excel/nested.htm

HTH,

Nicholas Hebb
BreezeTree Software
http://www.breezetree.com