Documentation/Calc Functions/IFNA

Function name:
IFNA

Category:
Logical

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

Syntax:
IFNA(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 #N/A error is found.

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


 * The IFNA function does not evaluate Otherwise Value if the evaluation of Then Value proceeds without a #N/A 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 IFNA 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

IFERROR

IFS

ISNA

NOT

OR

SWITCH

Special:MyLanguage/Documentation/Calc_Functions/TRUE

XOR

ODF standard:
Section 6.15.6, part 2

Equivalent Excel functions:
IFNA