Thread: 0 dvided by 0
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
paul paul is offline
external usenet poster
 
Posts: 247
Default 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