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?
|