1 Reply Latest reply: Nov 4, 2017 10:11 AM by Petter Skjolden RSS

    How to check if the fields from excel is '#N/A'?

    Stanley Cheong

      Does anyone knows how to check if the fields in a column is '#N/A'? i have tried some methods such as:

       

      if(not(left("ColumnName",1) = Chr(35)

      if(not(SubField("ColumnName",'N',1) = Chr(35)

       

      but nothing seems to work and i'm not sure why. It would only work if i find and replace every fields that are '#N/A' to '#NA' in the excel sheet