A
aquamanaj
i get an error when i put 0 divided by 0 in microsoft excel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
That is correct
=0/0 will produce an error.
=0/0 will produce an error.
J
James Silverton
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
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
P
PCLIVE
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)
add an IF statement to the beginning.
ex.
=IF(B1=0, "",A1/B1)
R
Ron Rosenfeld
i get an error when i put 0 divided by 0 in microsoft excel
What would you expect?
--ron
P
paul
yes you do #DIV/0
you can Trap it and move on.What ae you trying to do.?
you can Trap it and move on.What ae you trying to do.?