=IF(ISERROR(your_formula),0,your_formula)

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.