Filter by Categories
Select all
Business Statements
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Invoice/ Bill
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
Filter by File Types

Excel Logical Functions : IFNA

How to use IFNA Function in MS Excel

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.


  • 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

In VLOOKUP function, #N/A occurs when the lookup value is not in the lookup range and for that we have specified a meaningful message using IFNA.

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

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.


Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes