Nested IF statements

[maacmaac]

A cell in Excel contains 8 or 9 IF statements. The cell is returning #VALUE error; meaning there is a flaw in the formula. Is there a way to determine which part of the formula is being caculated without having to go through each IF statement one-by-one? I hope my question is clear. Any help would be great. Thanks.

[wjohnson]

Maximum number of "IF" statements is 7.

[goofy]

You can get around that limitation. The following webpage shows how
using defined names.
http://www.cpearson.com/excel/nested.htm



wjohnson wrote:
> Maximum number of "IF" statements is 7.
>
>
> --
> wjohnson
> ------------------------------------------------------------------------
> wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
> View this thread: http://www.excelforum.com/showthread...hreadid=504193

[daddylonglegs]

What's your formula?

Often if you're using multiple IFs there's a cleaner way with a LOOKUP function or similar