In this post, you’ll learn what is ISERROR function and how to use ISERROR function in your Excel Spreadsheet.
ISERROR in Excel
It is used to test for errors in a formula.
This function returns TRUE if it detects an error in the formula you’ve entered.
Syntax – ISERROR(value)
It checks for errors such as #NULL, #NAME?, #NUM!, #N/A, #VALUE!, #REF!, #DIV/0!.
When you use this function in a specific cell it returns TRUE if the cell referred to contains an error.
Let’s take a look at few examples.
Here the SUM function works properly so the ISERROR returns FALSE value.
In this case, it returns TRUE as the function’s syntax is wrong.