IFNA is a function that returns the result of the formula, otherwise the value you specify if the formula returns #Ref! error value.
Syntax: IFNA(value1,value2)
Return value2 if value1 is not number else returns value1.
For instance, IFNA((AC-PY)/PY, 0)
Returns AC-PY/PY if the value is a number else returns 0
Let us see how it works without and with IFNA statement.
A new row has been added to display the sum of Contoso and Proseware (Brand name) as shown below.
Without IFNA:
When the Brand name in the formula is unselected, the #Ref! error will be shown as below.
With IFNA:
Should you have any questions, kindly post it in comments.
