The ISERROR function is used to check if a value is an error and returns TRUE if it is an error value, such as #VALUE!, #REF!, #DIV/0!, and FALSE if it is any other type of value.



value The value or expression to check for an error.


When you need to swiftly ascertain if a particular value in your Excel spreadsheet is an error, the ISERROR function comes to your aid. It efficiently evaluates the presence of error values within a cell, aiding in error handling and data validation tasks. This function proves invaluable when analyzing large datasets or performing complex calculations where errors are a common occurrence. By utilizing the ISERROR function, you gain a quick and reliable method to identify errors, allowing you to address them promptly and ensure data accuracy and integrity.


Suppose cell A1 contains a formula that calculates the ratio of two numbers, which may sometimes result in a divide by zero error. You can check if the value in A1 is an error using the formula =ISERROR(A1). This will return TRUE if A1 contains an error value, such as #DIV/0!, and FALSE if it does not.

If you have a dataset where some cells contain error values due to incorrect input or formula errors, you can use ISERROR in combination with conditional formatting to highlight those cells for review and correction.


What types of error values can the ISERROR function detect?

The ISERROR function can detect a variety of error values in Excel, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, and #NULL! among others.

How does the ISERROR function work?

The ISERROR function evaluates the specified value or expression and returns TRUE if the value is any type of error and FALSE if it is a different type of value, such as a number, text, or logical value.

Can the ISERROR function be used in combination with logical functions?

Yes, the ISERROR function is often used in conjunction with logical functions like IF to handle errors in formulas. You can use ISERROR to check for errors and then apply conditional actions based on whether an error is present or not.

Related functions