IFNA

The IFNA function returns a specified value if the expression returns the #N/A error value, otherwise returns the result of the expression.

Syntax

=IFNA(value, value_if_na)

Parameters

• value: The value or expression to check for #N/A
• value_if_na: The value to return if value is #N/A

Examples

=IFNA(VLOOKUP(A1, B1:C10, 2), "Not Found") // Returns "Not Found" if VLOOKUP returns #N/A
=IFNA(1/0, "Error") // Returns 1/0 (division error) as it's not #N/A
=IFNA(NA(), "N/A Detected") // Returns "N/A Detected"