How do I replace the #DIV/0! with blanks in the cells?

[wanttolearn]

I'd like to replace #DIV/0!
with a blank or a 0 in the cells that have this after I copy a formula to a
range of cells. Replace doesn't recognize the symbol.

 

[CEMHamm]

To make your errors to your formulas not appear use the following

=if(iserror(your formula)," ",(type your formula again))

This should keep the cell blank until the right criteria is available for
your formula to calculate.

 

[Luke M]

Change your formula to
=IF(ISERROR(Youpreviousformula),"",Youpreviousformula)

If you want zeroes, replace the double quotes with 0.

 

[xlm]

try using this

=IF(ISERROR(Your formula),"",Your formula)

or

=IF(ISERR(Your formula),"",Your formula)

to place a 0 instead of blank, change "" to 0

HTH
--
Appreciate that you click on the Yes button below if this posting was
helpful.

Thank You

cheers, francis

 

[David Biddulph]

Rather than a blanket trap for all errors, which might hide a real problem,
better to look for divide by zero specifically.

So if your formula is =A1/B1, change it to
=IF(B1=0,"",A1/B1)