Help with #DIV/0! error please please help me
 

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

Help with #DIV/0! error please please help me
 

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

Help with #DIV/0! error please please help me
 

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

Help with #DIV/0! error please please help me
 

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

Help with #DIV/0! error please please help me
 

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