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.
Enter your email address to subscribe to this blog and receive notifications of new posts by email.