how to get rid of #N/A

V

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#DIV error 2
Count Names NOT #N/A 2
How to get rid of #n/a 1
Set add function ignore #N/A 1
getting rid of "#N/A" in columns 9
IF #N/A ( in a range), "ALERT","OK" 7
Removing #N/A from an "If/Then" statement 4
vlookup errors #n/a 10

Top