How do have Excel default the #n/a to display a zero by using a MACRO
J John Bundy May 7, 2008 #2 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.
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.
P Pete_UK May 7, 2008 #3 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
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
