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