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.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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 Google PlusVisit Us On Youtube