How to use ISERROR function in Excel?

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.

How to use the ISERROR function in Excel?
How to use the ISERROR function in Excel?

Here the SUM function works properly so the ISERROR returns FALSE value.

How to use the ISERROR function in Excel?

In this case, it returns TRUE as the function’s syntax is wrong.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.