Re: 0 divided by 0

Giganews Newsgroups
Subject: Re: 0 divided by 0
Posted by:  Peo Sjoblom (terre…@mvp.org)
Date: Mon, 13 Oct 2003

One way

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

--

Regards,

Peo Sjoblom

"frank" <mrfrank…@aol.com> wrote in message
news:05ae01c391c0$cb459830$a40128…@phx.gbl...
> In a formula if you divide 0 by 0 you get #DIV/01!
>
> Is there any way to get 0 as an answer.

Replies

None

In response to

0 divided by 0 posted by frank on Mon, 13 Oct 2003