Nested IF statements

M

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.
 
D

daddylonglegs

What's your formula?

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