overwrite error

[co-oplearning]

I have a simple formula in a cell which needs to remain there.

However sometimes due to the nature of my data, the error message #VALUE! appears.

I would like to be able to overwrite this message with a 0, meanwhile keeping the formula in the box.

Any suggestions?

Thanks!

[swatsp0p]

=IF(ISERR(your formula),"0",your formula)

Good Luck