Tom Farrar
asked on
Excel Nested IF Statement
Is such a nested if statement workable? As written it does not work. But the idea is if the calculation is an error (cell does not have a value to calculate), "Error", if the calculation has a negative result, "Negative Value", else the calculation result..
IF(ISERROR($Y2-$X2),"ERROR ",IF($Y2-$ X2)<0, "NEGATIVE TIME",$Y2-$X2)))
What is wrong with the formula, and/or is there a better way to do it? Thanks.
IF(ISERROR($Y2-$X2),"ERROR
What is wrong with the formula, and/or is there a better way to do it? Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome (we've all been there, those compound formulas can be tricky...).
»bp
»bp
ASKER
A set of "sharp eyes" fixed my formula. Thanks.
ASKER