Skip to main content


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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.