#N/A

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

--

Regards,

Peo Sjoblom


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

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)

--
Regards
Frank Kabel
Frankfurt, Germany

"Alicia" schrieb im Newsbeitrag
...
Is there a way to convert the answer #N/A to a zero in the
worksheet before you print it?

you can add this around/within your current formula;

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


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

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

Y2:

=HLOOKUP(...)

X2:

=IF(ISNA(Y2),0,X2)

Otherwise, if you'd want to keep #N/A's, you can use SumIf instead of Sum...

=SUMIF(Range,"#N/A")

"ftarrow" wrote in message
...
I am using hlookup and in some cases this is returning #n/a.
Is there a way of returning zero or blank so that it does not mess up an
add?

Hi
use
=IF(ISNA(HLOOKUP(...)),0,HLOOKUP(...))

--
Regards
Frank Kabel
Frankfurt, Germany


ftarrow wrote:
I am using hlookup and in some cases this is returning #n/a.
Is there a way of returning zero or blank so that it does not mess up
an add?