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 answers

  1.
    JvDo Posted messages 1924 Registration date   Status Member 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
    1. djowen
       
      Thank you, it helped me! Thanks again.
      0
    2. doctom
       
      thank you very much
      0