maybe resize your formula like this

=if(iserror(yourFormula),0,yourFormula)

--
*****
birds of the same feather flock together..



"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