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.