View original (French)

EXCEL, How to remove #N/A

Solved
David -  
 hilandI -
Hello,

I am working with Excel and I would like to know an effective way to remove the #N/A message in Excel.

I have found a method, but it is really not effective... (see point 1)

Point 1 Copy, paste as values and replace #N/A with nothing

Are you able to help me?

Thank you

David

3 réponses

Réponse 1 / 3
JvDo Posted messages 1924 Registration date   Status Membre Last intervention   859
 
Good evening,

in the formulas, you check for the occurrence of #N/A using the isna() function.
=if(isna(myformula);"";myformula)
See you!
235
djowen
 
Thank you, it helped me! Thanks again.
0
doctom
 
thank you very much
0