Iserror

[Ranger32195]

Hi,

Could anyone tell me how to put an ISERROR in to the following formula:

=IF(OR(ABS((+C3-A3)/A3)>=50%,ABS((+C3-A3)/A3)<=-50%),"Explanation Required","OnTrack")

Basically, if the value of A3 is 0 I get a DIV/0 error when in fact it should be returning "Explanation Required"

Thanks in advance

 

[SteveO59L]

=IF(iserror(OR(ABS((+C3-A3)/A3)>=50%,ABS((+C3-A3)/A3)<=-50%)),"Explanation Required","OnTrack")

 

[Seti]

Try this:

=IF(A3=0,"Explanation Required",IF(OR(ABS((+C3-A3)/A3)>=50%,ABS((+C3-A3)/A3)<=-50%),"Explanation Required","OnTrack"))

 

[Colin Legg]

I'm curious as to when this part of the formula could return TRUE?

ABS((+C3-A3)/A3)<=-50%

So that would lead to....

=IF(A3,IF(ABS((C3-A3)/A3)>=50%,"Explanation Required","OnTrack"),"Explanation Required")