How to use Excel ISERROR Function


ISERROR function in excel is an information function. It is used to find out whether cells contain an error value including the #N/A error. It returns TRUE if cell contains an error value otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required.




  • Value:  It is the value which will be tested. It can be in form of an empty cell, an error, number, text, logical value etc.


  • Values of the arguments in ISERROR function are not converted.
  • This function can be used with functions like IF function, testing outcomes, locating errors etc.


In this example, various error values are entered in column B with some of them left without errors, and ISERROR function is used to find out which of them have error values and which of them do not.

Leave a Comment

Your email address will not be published. Required fields are marked *