ISERROR function in Excel

Use

Checks whether a value is an error or not

Description

ISERROR function returns with TRUE if the value has an error otherwise FALSE. Excel generates following errors: #REF!, #N/A, #VALUE!, #DIV/0!  , #NUM!, #NAME?, or #NULL!.

Syntax

=ISERROR (value)

(value) is the value to check for errors.

Example

To point out errors from your data before further calculations, you may use together IF function with  ISERROR function. For example,

Formula:

= IF( ISERROR(A1), “An error occurred.”, A1 * 2)

Result:

Excel will return with “An error occurred” if there is error in data, otherwise, it will perform the calculation A1 * 2.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved