IFNA

The IFNA function returns the specified value if an expression results in the #N/A error; otherwise, it returns the result of that expression.

Syntax#

IFNA(value, value_if_na)

Arguments#

• value: The expression to evaluate for the #N/A error.
• value_if_na: The value to return if the expression results in the #N/A error.

Return value#

Returns either the result of the value or value_if_na if the #N/A error occurs.

Example#

IFNA((Actuals - Plan) / Plan, 0)

Returns (Actuals - Plan) / Plan if the expression evaluates successfully; otherwise, returns 0 if the #N/A error occurs.

Excel equivalent#

IFNA