Documentation/Calc Functions/IFNA

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

IFNA

Category:

Logical

Summary:

Returns the value if the cell does not contains the #N/A (value not available) error value, or the alternative value if it does.

Syntax:

IFNA(Value;Alternate_value)

Returns:

Arguments:

Value is the value or expression to be returned if it is not equal or results in an #N/A error.

Alternate_value is the value or expression to be returned if the expression or value of Value is equal or results in an #N/A error.

Additional details:

Examples:

=IFNA(D3;D4) returns the value of D3 if D3 does not result in an #N/A error, or D4 if it does.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: