Documentation/Calc Functions/IFNA
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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.