Skip to main content

IFERROR

Returns specified ErrorValue, if given value represents an error. If not, this function simply returns given value.

Syntax

=IFERROR(Value, ErrorValue)

Arguments

NameDescription
ValueValue to check against each defined error values.
ErrorValueThe value to return, if first value returns an error.

Return Value

ErrorValue, if error occurs, otherwise the Value.

Example

FunctionResultComment
=IFERROR(2 / 0, "Warning")"Warning"As the Value leads to a DIV/0 error, the text "Warning" is displayed.