Ranger32195
Board Regular
- Joined
- Feb 4, 2009
- Messages
- 131
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
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