IFNA

The IFNA function returns the value you specify if a formula returns the #N/A error value; otherwise, it returns the result of the formula.

Syntax

ifna(value1,value2)

Arguments

value1- 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.

IFNA example

Excel equivalent

IFNA