#DIV/0! replaced by 'O'

I

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
 
P

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
 
Top