Even if you could put 30 IF functions in a formula (you can't,
you're limited to 7 levels of parens), the formula would be
nearly unreadable and unmaintainable. Most likely, there is a
better way, probably using either CHOOSE or VLOOKUP. If you post
an explanation of what you are attempting to achieve, you'll
likely get a desirable formula.
As previously mentioned, you only have 7 nests. In Office 12 you will have,
I believe, 64. Why? I don't know. I would never want to use that many
anyway. There is generally a better way with other formulas as well.
--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.
