software

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.--
maacmaac
------------------------------------------------------------------------
maacmaac's Profile: www.excelforum.com/member.php...foamp;userid=2959
View this thread: www.excelforum.com/showthread...hreadid=504192If you're using xl2002 , you can use:

Tools|formula auditing|evaluate formula

In earlier versions, you can select portions of the formula in the formula bar
and hit f9 to see how that portion evaluates.

Hit escape to reset the formula back to what it was--or ctrl-z to just reset
that portion of the formula.

maacmaac wrote:
gt;
gt; A cell in Excel contains 8 or 9 IF statements. The cell is returning
gt; #VALUE error; meaning there is a flaw in the formula. Is there a way
gt; to determine which part of the formula is being caculated without
gt; having to go through each IF statement one-by-one? I hope my question
gt; is clear. Any help would be great. Thanks.
gt;
gt; --
gt; maacmaac
gt; ------------------------------------------------------------------------
gt; maacmaac's Profile: www.excelforum.com/member.php...foamp;userid=2959
gt; View this thread: www.excelforum.com/showthread...hreadid=504192

--

Dave Peterson

I believe you'll also find that Excel permits nesting up to a maximum of 7
levels deep (not 8 or 9). This could also be your problem.
- Will

quot;Dave Petersonquot; wrote:

gt; If you're using xl2002 , you can use:
gt;
gt; Tools|formula auditing|evaluate formula
gt;
gt; In earlier versions, you can select portions of the formula in the formula bar
gt; and hit f9 to see how that portion evaluates.
gt;
gt; Hit escape to reset the formula back to what it was--or ctrl-z to just reset
gt; that portion of the formula.
gt;
gt; maacmaac wrote:
gt; gt;
gt; gt; A cell in Excel contains 8 or 9 IF statements. The cell is returning
gt; gt; #VALUE error; meaning there is a flaw in the formula. Is there a way
gt; gt; to determine which part of the formula is being caculated without
gt; gt; having to go through each IF statement one-by-one? I hope my question
gt; gt; is clear. Any help would be great. Thanks.
gt; gt;
gt; gt; --
gt; gt; maacmaac
gt; gt; ------------------------------------------------------------------------
gt; gt; maacmaac's Profile: www.excelforum.com/member.php...foamp;userid=2959
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=504192
gt;
gt; --
gt;
gt; Dave Peterson
gt;