#DIV/O! Errror with Absolute Number Calculation
Try this...
=IF(K41="","N/A",ABS(K41-J41)/ABS(K41))
--
Biff
Microsoft Excel MVP
"Brent" wrote in message
...
Hi,
I am calculating the following formula.
=ABS(K41-J41)/ABS(K41)
The result is #DIV/O! many times because K41 is 0 and the result is
#DIV/O!
I'd like the result to be "N/A" or something that I could put in between
parenthesis.
I'd be happy with any recommendations you have.
Thanks!!
|