How do have Excel default the #n/a to display a zero by using a MACRO
--
Mike Davis

You dont have to use a macro for this, wrap your formula in a isna:
if(isna(formula),"0",formula)

basically the same thing if you do it in a macro.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Mike Davis" wrote:

How do have Excel default the #n/a to display a zero by using a MACRO
--
Mike Davis

If the #N/A is caused by a lookup or match formula, then you can do
this to your formula:

=IF(ISNA(your_formula),0,your_formula)

Hope this helps.

Pete

On May 7, 2:15*pm, Mike Davis
wrote:
How do have Excel default the #n/a to display a zero by using a MACRO
--
Mike Davis