Broadly speaking, you could write your formula similar to
=IF(ISERROR(original_formula),0,original_formula)
The disadvantage to this method is that original_formula will be calculated
twice, which may be a noticeable performance hit. In Excel 2007, you can use
the IFERROR function: =IFERROR(your_formula,0)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting www.cpearson.com
(email on the web site)
