View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brent Brent is offline
external usenet poster
 
Posts: 109
Default #DIV/O! Errror with Absolute Number Calculation

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