how to remove #DIV/0!

  • Thread starter Thread starter kuansheng
  • Start date Start date
K

kuansheng

Hi Guys,

I am trying to apply division on two cell and sometimes i will have 0
in both cell which will result in a 0 divided by 0 which excel will
prompt an error #DIV/0! . Snyone could advice me how can I replace the
error message with a 0 instead of #DIV/0!. What i am trying to get is
whenever there is a zero divide by a zero the result will show a zero
instead of #DIV/0! Thsnk you.

regards,
kuansheng
 
Thanks Pete. I tried both method they work like a charm. Learn
something new. Thanks
 
Biff's method traps all errors and returns a zero instead of the error
message, whereas my method specifically avoids the #DIV/0 error, as you
requested. If A1 contained some text, then you would get the error
message #VALUE if you used my formula - just different approaches.

Pete
 
Back
Top