- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Re: 0 divided by 0

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.

None

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