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)If the value is a number, the function returns (AC-PY)/PY; otherwise, it returns 0.
Excel equivalent
Last updated