how to get rid of #N/A
 

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! :confused:


--
vitality
------------------------------------------------------------------------
vitality's Profile: http://www.excelforum.com/member.php...o&userid=27267
View this thread: http://www.excelforum.com/showthread...hreadid=467807

Try

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

--
HTH

Bob Phillips

"vitality" wrote in
message ...

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! :confused:


--
vitality
------------------------------------------------------------------------
vitality's Profile:
http://www.excelforum.com/member.php...o&userid=27267
View this thread: http://www.excelforum.com/showthread...hreadid=467807

It did work!
Thanks.


--
vitality
------------------------------------------------------------------------
vitality's Profile: http://www.excelforum.com/member.php...o&userid=27267
View this thread: http://www.excelforum.com/showthread...hreadid=467807