Couple of ways to do this.

1. Trap in the first set of formulas so the error doesn't occur

=IF(B1=0,"",A1/B1)

2. Trap the error after the fact.

=IF(ISERROR(A1/B1),0,A1/B1)


Gord Dibben MS Excel MVP




On Tue, 23 Jan 2007 14:42:01 -0800, elixus
wrote:

I am curently writing a spreadsheet and i have formulae in this sheet where
sometimes i expect to have the #div/0 error but my problem is i have other
formulae that use cells containing the #div/0 error so my question is how can
i make a cell show a 0 instead of the #div/0 error so it won't effect other
formulae.

any help on this topic would be very very much appreciated