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