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)


"AG" wrote in message
...
Hi,

How to get '0' in place of #DIV/0! and #N/A

Thanks