View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default Zero divided by Zero

Maybe use an IF statement to check if the divisor is 0

A1=0 or any number
B1=0

In C1, enter

=IF(B1=0, 0, A1/B1)


--
Hope that helps.

Vergel Adriano


"TheNYCer" wrote:

Is there a formula that will allow zero divied by zero to equal zero
rather than giving an error?