Calc IFNA function

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the IFNA function.

Description

Returns the value you specify if the expression evaluates to the #N/A error; otherwise, it returns the result of the expression.

Syntax

IFNA(expression, value_if_na)

• expression - Required. The expression to check for the #N/A error.
• value_if_na - Required. The value to return if expression evaluates to the #N/A error.

Remarks

• If expression does not evaluate to the #N/A error, IFNA returns the result of expression.
• If expression evaluates to the #N/A error, IFNA returns value_if_na.
• IFNA only catches #N/A errors. If you want to catch all errors, use the IFERROR function instead.

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc IFERROR function
• Calc IFNULL function
• Calc ISEVEN function
• Calc ISIMAGE function
• Calc ISNUMBER function