Documentation/Calc Functions/IFERROR

Function name:
IFERROR

Category:
Logical

Summary:
Evaluates one argument and if no error is found, the value of that argument is returned. If an error is found, then a second argument is evaluated, and its value is returned.

Syntax:
IFERROR(Value; Alternative Value)

Returns:
Returns a value whose type depends on the argument selected as the return value.

Arguments:
Value is an expression, or a reference to a cell containing an expression, that is evaluated and returned if no error is found.

Alternative Value is an expression, or a reference to a cell containing an expression, that is evaluated and returned only if an error was found during the evaluation of Value.


 * The IFERROR function does not evaluate Otherwise Value if the evaluation of Then Value proceeds without an error. For example, the formula  returns 23. While   might be expected to generate a #DIV0! error, the division is never attempted in this case.

Details specific to IFERROR function
is semantically equivalent to, except that the former case is more efficient because X is only computed once.

Related LibreOffice functions:
AND

Special:MyLanguage/Documentation/Calc_Functions/FALSE

IF

IFNA

IFS

ISERROR

NOT

OR

SWITCH

Special:MyLanguage/Documentation/Calc_Functions/TRUE

XOR

ODF standard:
Section 6.15.5, part 2

Equivalent Excel functions:
IFERROR