Excel Logical Functions : IFNA

Introduction to IFNA Function

Logical functions in Excel are predefined formulas that evaluate a given condition or set of conditions and return a Boolean value (TRUE or FALSE) based on whether the condition is met or not. They are used to test the truth or falsehood of a statement or a condition, and to make decisions based on the result. In this blogpost, we will discuss about IFNA Function in Excel.

IFNA function returns a specific value if an #N/A error occurs. Unlike IFERROR, it only evaluates the #N/A error and returns the value you specified.

Download Sample File

Download SAMPLE FILE to work, practice and master the LOGICAL Functions in Excel.

Syntax of IFNA Function

IFNA(value, value_if_na)

Arguments of IFNA Function

• value: The value you want to test for #N/A error.
• value_if_na: The value you want to return if an error occurred.

Notes

• If you skip specifying any argument, IFNA will treat it as an empty string (“”).
• If a value is an array then it will return the result as an array.
• It will ignore all other errors #REF!, #DIV/0!, #VALUE!, #NUM!, #NAME?, and #NULL!.

Example of IFNA Function in MS Excel

Other Excel Logical Functions Tutorials

You can explore and master other Logical functions in Microsoft Excel. Here is a complete list of Logical functions available in Microsoft Excel.

• AND Function
• FALSE Function
• IF Function
• IFERROR Function
• IFNA Function
• NOT Function
• OR Function
• TRUE Function