Modify your formula to check for ERROR

Example:
=IF(ISERROR(A1/$A$20),0,A1/$A$20)

Hope this helps,
Francis Hayes (The Excel Addict)
www.TheExcelAddict.com



"Fabbe" wrote:

Hi,

Can anyone tell me how I can change an error msg (f.e.
#DIV/O!) by any value ?

I have a formula that generates an error msg, but I want
to change it by ZERO.

Thanks,
Fabian