#N/A

  • Thread starter Thread starter Alicia
  • Start date Start date
A

Alicia

Is there a way to convert the answer #N/A to a zero in the
worksheet before you print it?
 
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
 
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)
 
you can add this around/within your current formula;

IF(ISNA(your formula),0,your formula)
 
Alicia wrote,
Is there a way to convert the answer #N/A to a zero in the
worksheet before you print it?
Click to expand...

Alicia,

Yes,

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

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

Best regards,
Kevin
 
Back
Top