Zero divided by Zero
 

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

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?

Zero divided by Zero
 

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?

Zero divided by Zero
 

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?