ISNA returns TRUE if the value is the #N/A error value : ISNA « Information functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Information functions
  3. ISNA
Fill A1 with =NA()
Fill A1 with =NA()
Input the formula: =ISNA(A1). Press Enter to get the result.
Input the formula: =ISNA(A1)
17.9.ISNA
17.9.1.ISNA returns TRUE if the value is the #N/A error valueISNA returns TRUE if the value is the #N/A error value
17.9.2.Return the total number of #NA error values in a range named Data