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

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

Luke M
*Remember to click "yes" if this post helped you!*


"wanttolearn" wrote:

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.