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
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
Returns AC-PY/PY if the value is a number else returns 0
Excel equivalent
Last updated