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!