Excel Function : IFNA

Download now!

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.