Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF statements
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: http://www.excelforum.com/member.php...fo&userid=2959 View this thread: http://www.excelforum.com/showthread...hreadid=504192 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF statements
If 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: 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: http://www.excelforum.com/member.php...fo&userid=2959 View this thread: http://www.excelforum.com/showthread...hreadid=504192 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF statements
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 "Dave Peterson" wrote: If 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: 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: http://www.excelforum.com/member.php...fo&userid=2959 View this thread: http://www.excelforum.com/showthread...hreadid=504192 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple nested IF statements | Excel Worksheet Functions | |||
How to add more than 7 if nested statements. 7 is the limit. | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
Employing constant arrays to limit nested IF statements. | Excel Worksheet Functions | |||
nested statements | New Users to Excel |