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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
