#DIV/0! replaced by 'O'

[imageres]

Is there a simple way of setting up a work sheet so that the #DIV/0 i
automatically replaced by a zerro?

Thanks Dou

 

[Peo Sjoblom]

Since the errors must come from formula you can amend the formulas like

=IF(divisor=0,0,dividend/divisor)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom