how to get rid of #N/A

[vitality]

Hi all

I have a formula, due to unmatch data from another table, some cell has "#N/A" show up, how could I replace #N/A with [nothing ""] in the cell?

I try to use the if function, such as
=IF(A1="#N/A","",A1)
However, if the A1 is #N/A ... is still show up as #N/A .

Can anyone help me .... thanks for yr help!

[Bob Phillips]

Try

=IF(ISNA(A1),"",A1)

--
HTH

Bob Phillips

"vitality" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all
>
> I have a formula, due to unmatch data from another table, some cell has
> "#N/A" show up, how could I replace #N/A with [nothing ""] in the cell?
>
> I try to use the if function, such as
> =IF(A1="#N/A","",A1)
> However, if the A1 is #N/A ... is still show up as #N/A .
>
> Can anyone help me .... thanks for yr help!
>
>
> --
> vitality
> ------------------------------------------------------------------------
> vitality's Profile:
http://www.excelforum.com/member.php...o&userid=27267
> View this thread: http://www.excelforum.com/showthread...hreadid=467807
>

[vitality]

It did work!
Thanks.