ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   0 dvided by 0 (https://www.excelbanter.com/excel-discussion-misc-queries/113247-0-dvided-0-a.html)

aquamanaj

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

Gary''s Student

0 dvided by 0
 
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


James Silverton

0 dvided by 0
 
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


PCLIVE

0 dvided by 0
 
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




Ron Rosenfeld

0 dvided by 0
 
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

paul

0 dvided by 0
 
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






All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com