IFERROR
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 ifvalue
itself is not an error.value_if_error
- [ OPTIONAL - blank by default ] - The value the function returns ifvalue
is an error.
Notes
IFERROR(exp1,exp2)
is logically equivalent toIF(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.