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

Hi!

One way:

=IF(ISERROR(A1/B1),0,A1/B1)

Biff

"kuansheng" wrote in message
oups.com...
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 Biff. That very helpful...

Another way:

=IF(B1=0,0,A1/B1)

Hope this helps.

Pete

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

...or...

=IF(B1,A1/B1,0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=538716

Thanks I have tried both method work great. Million thanks.

kuansheng