How do we replace "#DIV/0!" with a numeric zero in a worksheet? Thx!
J Jason Morin Sep 11, 2003 #2 You're dividing by zero. Counteract that by modifying the formula you're using. A simple example would be: =IF(A1=0,0,B1/A1) or trap the error: =IF(ISERROR(your_formula),0,your_formula) HTH Jason Atlanta, GA
You're dividing by zero. Counteract that by modifying the formula you're using. A simple example would be: =IF(A1=0,0,B1/A1) or trap the error: =IF(ISERROR(your_formula),0,your_formula) HTH Jason Atlanta, GA
