Excel Function : IFNA
Category
Logical
Description
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
Microsoft Excel Reference Page
https://support.office.com/en-us/article/IFNA-function-6626c961-a569-42fc-a49d-79b4951fd461
Syntax and Description of the IFNA Excel Function
The syntax for the IFNA function in Microsoft Excel is: = IFNA ( value , value_if_na ) Where the function arguments are: value - The value to check. - The value to check. value_if_na - The value to return if value is #N/A. For example: = IFNA ( A1 , 0 ) // Returns 0 if A1 is #N/A = IFNA ( A1 , B1 ) // Returns the value in B1 if A1 is #N/A = IFNA ( A1 , "N/A" ) // Returns "N/A" if A1
About IFNA Excel Function
The IFNA function returns the value you specify if the formula returns the #N/A error value. Otherwise, it returns the result of the formula.
