Does this mean I have to write my long formula twice?

Yes, but you can always copy/paste rather than type.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

"Chris" wrote in message
...
On Feb 14, 3:09 pm, "Chip Pearson" wrote:
If you are using Excel 2003 or earlier, you can use a formula like

=IF(ISERROR(your_formula),0,your_formula)

In Excel 2007, you can use

=IFERROR(your_formula,0)

In both cases, substitute your formula (without the leading '=') in the
formulas above.

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLCwww.cpearson.com
(email on web site)

"Chris" wrote in message

...



I was hoping someone could help me out in making the #div/0 error
removed and replaced by a 0.
Here is my formulal:

=AVERAGE(IF('Filled All'!I1:I1000="JS",IF('Filled All'!
N1:N1000="IT",IF('Filled All'!B1:B1000="A",IF('Filled All'!
M1:M10000.001,'Filled All'!M1:M1000)))))

Any help is appreciated, Thanks!

-Chris- Hide quoted text -

- Show quoted text -

Does this mean I have to write my long formula twice?