Hide cells with Errors using ISERROR or IFERROR fuction

image_pdf

We can use ISERROR  or IFERROR function to tackle and handle errors of database. Mostly Errors are the result of formula. Display blank or give proper message for error using IFERROR or ISERROR function

Download file: ISERROR and IFERROR

How to use ISERROR function in excel?

ISERROR function checks if the value in cell is an error or not. If it is an Error, returns TRUE otherwise FALSE.

Syntax:

=ISERROR( value )

Value: Provided value or result from a formula or a cell reference

Let us see an example to understand in detail.

Example:

This example checks the value in cell A1 and A2 whether there is any error or not.

iserror1

iserror2

How to use IFERROR function in excel?

IFERROR function checks whether specified cell value is an Error. In case of error it returns user specified value. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

IFERROR function has been introduced in Excel 2007 and later.

Syntax:

= IFERROR( value, value_if_error )

Where value: The value that needs to be tested.

Value_if_error: The value that needs to be returned if value argument returns an error.

Example:

For example, in this case B1 is 0, so A1/B1 will show an error. IFERROR function will display the user specified value "invalid" in the result cell

=IFERROR(A1/B1, "invalid ")

iferror1

TIP: Display blank ("") if error evaluates to an error. That will be useful to manage your data

IFERROR function is really useful when you don't want to show the cells with an error. Display blank ("") in case of error. That way you can easily tackle with the errors of your workbook and keep your workbook neat and clean.

How to handle error using ISERROR, if you are using Excel 2003 or earlier version?

Use ISERROR with IF Function which works as similarly as IFERROR.

For example, we can use ISERROR with IF function, So if ISERROR results in true( In this case, A1/B1), provide the message you want to display in [Value_if_True] step.(i.e."invalid"), and In [Value_if_False] step,( which means A1/B1 result is some value), you can write the same formula again(i.e. A1/B1)

IF (ISERROR (A1/B1,"Invalid",A1/B1) Works same as,= IFERROR(A1/B1, "invalid ")

If you find this useful, you can stay connected with us on facebook to get more amazing tips and tricks of Microsoft excel.
 

3,642 total views, 4 views today

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>