I have used IF(ISERROR(formula cell address),0,formula cell address)
#DIV/0! 0.00
A1 IF(ISERROR(A1),0,A1)



"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