Hi
change your formula to something like
=IF(B1=0,0,A1/B1)

--
Regards
Frank Kabel
Frankfurt, Germany

"Fabbe" schrieb im Newsbeitrag
...
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