![]() |
0 dvided by 0
i get an error when i put 0 divided by 0 in microsoft excel
|
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 |
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 |
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 |
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 |
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