How to Use ISERROR Function in Excel

In this article, we will learn the function ISERROR in Excel.

ISERROR is a built-in function. It is an information function which checks the condition and returns TRUE if there’s any error and False if not.

ISERROR checks for various errors in the condition like #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.
Syntax:

=ISERROR(condition)

Now let’s use on data here.
1
First we calculate Rate/kg using simple division formula
C2/B2.
2
As you can see we are getting error messages.

So we will use this formula

=ISERROR(D2)

Which results True or False as shown in the snapshot below.
3
Hope you understood how to use ISERROR function in Excel 2016. Find more articles on information functions here. Please share your query below in the comment box. We will assist you.

Related Articles:

IF function with Wildcards

IF with OR Function in Excel

IF with AND Function in Excel

Popular Articles:

50 Excel Shortcut to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF function in Excel 2016

How to Use SUMIF Function in Excel

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube