This post will guide you how to use **Excel IFNA function** with syntax and examples in Microsoft excel.

**Description**

The Excel IFNA function returns an alternate value you specify if a formula results in an #N/A error, or returns the result of the formula.

The IFNA function is a build-in function in Microsoft Excel and it is categorized as a Logical Function.

The IFNA function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

**Syntax**

The syntax of the IFNA function is as below:

**= IFNA (value, value_if_error)**

**Where** the IFNA function arguments are:

**Value** -This is a required argument. The value or formula that you want to test

**Value_if_error** – This is a required argument. The value that is returned if the formula evaluates to a #N/A! error.

**Example**

The below examples will show you how to use Excel IFNA Function to return an alternate value if a formula evaluates to a #N/A! error.

**#1 =IFNA(VLOOKUP(2019,A1:B5,2,FALSE),2019)**

Note: the formula “**VLOOKUP(2019,A1:B5,2,FALSE)**,” will return an **#N/A! Error**, if you use “IFNA” function, the above excel formula will return an alternate value “**2019**”.

Related Posts

Excel XLOOKUP Function
Excel XLOOKUP Function was added into Excel as a beta feature in August 2019 and is now accessible exclusively in Microsoft 365. (as of July 2021). However, if you fall into this category and often deal with big sets of ...

Excel NOT Function
This post will guide you how to use Excel NOT function with syntax and examples in Microsoft excel. Description The Excel NOT function returns the opposite of a given logical or Boolean value. For example, if you supplied with the ...

Excel IF Function With Dates
If you have a list of dates and then want to compare to these dates with a specified date to check if those dates is greater than or less than that specified date. You can use the IF function in ...

Excel IF function with text values
Normally, If you want to write an IF formula for text values in combining with the below two logical operators in excel, such as: “equal to” or “not equal to”. Excel IF function check if a cell contains text(case-insensitive) By default, ...

Excel IF Function With Numbers
Normally, If you want to write an IF formula for numbers in combining with the logical operators in excel, such as: greater than, less than, greater than or equal to, less than or equal to, equal to, not equal to.etc. ...

Excel IF formula with NOT logical function
This post will guide you how to use excel if formula with NOT logical function in Microsoft excel. NOT Logical Function The syntax of NOT logical function is as follow: =NOT(logical_value) The NOT logical function will return the reversed logical ...

Excel IF formula with AND & OR logical functions
If you want to test the result of cells based on several sets of multiple test conditions, you can use the IF function with the AND and OR functions at a time. Assuming that you have the following test logic to check ...

Excel IF formula with OR logical function
This post will guide you how to use IF function combining with OR logical function in Excel. If you want to check if one of several conditions is met in your excel workbook, if the test is TRUE, then you ...