Definition of IFERROR

Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.

Sample Usage

IFERROR(A1,"Error in cell A1")

IFERROR(A2)

Syntax

IFERROR(value, [value_if_error])

  • value - The value to return if value itself is not an error.

  • value_if_error - [ OPTIONAL - blank by default ] - The value the function returns if value is an error.

Notes

  • IFERROR(exp1,exp2) is logically equivalent to IF(NOT(ISERR(exp1)),exp1,exp2). Ensure that this is the desired behvaior.

See Also

ISNA: Checks whether a value is the error `#N/A`.

ISERROR: Checks whether a value is an error.

ISERR: Checks whether a value is an error other than `#N/A`.

IF: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.

In order to use the IFERROR formula, start with your edited Excellentable

 

Then type in the IFERROR Formula in the area you would like to display the outcome:

 

Type in the complete IFERROR formula for a cell as shown below:

 

Excellentable will generate the outcome when hitting enter. 

Error.

User does not have sufficient privileges to access this Content
Learn More