#N/A

[Alicia]

Is there a way to convert the answer #N/A to a zero in the
worksheet before you print it?

 

[Peo Sjoblom]

Select the range, press F5, select special,
select formulas and uncheck everything except errors, click OK
type 0 (while still selected) and press Ctrl + Enter

Note that this will remove all formulas returning this error and
replace them by zeros

 

[Frank Kabel]

Hi
one way: use conditional format to HIDE this value:
- select the cell
- goto 'format - Conditional Format'
- enter the formula
=A1=NA()
if A1 is the cell you selected
.. choose a white font color as format

Another way:
change your formula as follows:
=IF(ISNA(your_formula),0,your_formula)

 

[Dave R.]

you can add this around/within your current formula;

IF(ISNA(your formula),0,your formula)

 

[Kevin Stecyk]

Alicia wrote,

Is there a way to convert the answer #N/A to a zero in the
worksheet before you print it?

Alicia,

Yes,

=IF(ISNA(YourPriorFormula), 0, YourPriorFormula)

This tests if #N/A shows up, and if so, then 0, otherwise evaluate.

Best regards,
Kevin