Home ► Excel Functions ► Excel IFNA Function

Syntax For Excel IFNA Function

What is the use of Excel IFNA Function?

By using Excel IFNA Function you can evaluate a value for #N/A. If an error occurs you can change it by some specific value or with a more meaningful message and if an error doesn’t occur it will return original value. Unlike IFERROR Function, IFNA test for #N/A only.

Defination for Excel IFNA Function

In above example, I have used IFNA to deliver a meaningful message for an error. You can use this type of formula to evaluate & specify a particular message against #N/A.

Syntax for Excel IFNA Function

IFNA(value, value_if_na)

value Value you want to test for #N/A error. [Required]

value_if_na Value you want to return if an error occurred. [Required]

More Information on TRUE Function

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

Examples on TRUE Function

Examples For Excel IFNA Function

In above example, I have used IFNA to evaluate #N/A. In VLOOKUP Function #N/A will occur when the lookup value is not in the lookup range and for that I have specified a meaningful message.

Note: IFNA Function is introduced in Excel 2013 so it is not available in previous versions.

Download Sample File

Download Sample File To Learn Excel IFNA Function

More Tips Related With Excel IFNA Function


You can use Excel IFNA Function in some other mega function to deliver a meaningful message to your user. And, If you want to evaluate all other functions you can use IFERROR FunctionLearn more about TRUE from here.

Related Function


Excel Functions | Excel Formulas