ISERROR returns TRUE if the value is any error value : ISERROR « Information functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Information functions
  3. ISERROR
Fill A1 with: =1/0
Fill A1 with: =1/0
Input the formula: =ISERROR(A1). Press Enter to get the result.
Input the formula: ISERROR(A1)
17.6.ISERROR
17.6.1.ISERROR returns TRUE if the value is any error valueISERROR returns TRUE if the value is any error value
17.6.2.Return the total number of error values in a range named Data