IFNA

The IFNA function evaluates an expression and returns a specified value if the expression returns an #N/A error; otherwise, it returns the value of the expression itself.

Syntax

IFNA(value,value_if_error)

Arguments

value- The argument that is checked for the #N/A error value.

value2- The value to return if the formula evaluates to the #N/A error value.

Return value

Either value1 or value2.

Example

ifna((AC-PY)/PY, 0)

Returns (AC-PY)/PY if the value is a number; else, returns 0.

Excel equivalent

IFNA