I imageres Jun 7, 2004 #1 Is there a simple way of setting up a work sheet so that the #DIV/0 i automatically replaced by a zerro? Thanks Dou
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 Jun 8, 2004 #2 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
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
