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.

Leave A Reply

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

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021