Hi,

Firstly your formula can be simplified to

=ABS((K41-J41)/K41)

and to get NA# instead of div/0 use

=IF(K41=0,NA(),ABS((K41-J41)/K41))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Brent" wrote:

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!!