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

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

Just for the record, Excel 2007 has a new function called IFERROR.

=IFERROR(your_formula,value_if_formula_error)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"driller" wrote in message
...
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

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

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