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(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.


  • 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. 


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