i get an error when i put 0 divided by 0 in microsoft excel

That is correct
=0/0 will produce an error.
--
Gary's Student


"aquamanaj" wrote:

i get an error when i put 0 divided by 0 in microsoft excel

Hello, aquamanaj!
You wrote on Fri, 6 Oct 2006 14:36:02 -0700:

a i get an error when i put 0 divided by 0 in microsoft excel

Of course you do! Divide by zero is undefined no matter what it
is working on.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

That's correct. You can't divide by zero. If it is a formula, then you can
add an IF statement to the beginning.

ex.
=IF(B1=0, "",A1/B1)



"aquamanaj" wrote in message
...
i get an error when i put 0 divided by 0 in microsoft excel

On Fri, 6 Oct 2006 14:36:02 -0700, aquamanaj
wrote:

i get an error when i put 0 divided by 0 in microsoft excel

What would you expect?
--ron

yes you do #DIV/0
you can Trap it and move on.What ae you trying to do.?
--
paul

remove nospam for email addy!



"PCLIVE" wrote:

That's correct. You can't divide by zero. If it is a formula, then you can
add an IF statement to the beginning.

ex.
=IF(B1=0, "",A1/B1)



"aquamanaj" wrote in message
...
i get an error when i put 0 divided by 0 in microsoft excel