T TheNYCer Jun 22, 2007 #1 Is there a formula that will allow zero divied by zero to equal zero rather than giving an error?
G Guest Jun 22, 2007 #2 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)
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)
G Guest Jun 22, 2007 #3 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.
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.
G Guest Jun 22, 2007 #4 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.
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.
