Hi Stephen,

I believe the problem happens only when you divide a number by 0. 0 divided
by a non 0 value will equal to 0, so you need not check if A1 is 0.


--
Hope that helps.

Vergel Adriano


"Stephen" wrote:

you could also nest two IF's...

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

that way if either cell is equal to zero it will not return the divide by
zero error but instead return 0.

"Vergel Adriano" wrote:

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?