Excel's IFNA function returns the specified value

Buzz

Ngày cập nhật gần nhất: 15/4/2026

Content

Excel's IFNA function

1. Description of the IFNA function in Excel, returning the specified value

2. Example of the IFNA function in Excel, returning the specified value

Excel's IFNA function swiftly returns your specified value, ensuring your tasks proceed swiftly while maintaining high accuracy. Let's delve into the details of this Excel IFNA function with Mytour to utilize it most effectively.

Apart from Excel's IFNA function, returning the specified value. Readers can also explore some previous articles to understand better how to use the Round and COUNTIF functions in Excel.

Excel's IFNA function

1. Description of the IFNA function in Excel, returning the specified value

The IFNA function in Excel checks whether a provided initial value (or expression) returns an Excel #N/A error value or not. If it does, the function returns the second provided value; otherwise, it returns the first provided value.

The syntax of the IFNA function in Excel is:

IFNA( value, value_if_na )

Where:
- value: The value or expression being checked.
- value_if_na: The value or expression to be returned if the first provided value returns the # N/A error.

Note: The IFNA function is a new function in Excel 2013, so it is not available in earlier versions of Excel.

2. Example of the IFNA function in Excel, returning the specified value

Example 1

The following spreadsheet illustrates 2 simple examples of the IFNA function in Excel:

Formula:

Returned result:

Example 2

In cells D1 and D2 of the following spreadsheet, the IFNA function in Excel is used to check the results of the Excel Vlookup function.

Formula:

Returned result:

See also: The REPLACE function in Excel

Above, Mytour has introduced you to some information as well as examples of the IFNA function in Excel, returning the specified value. To better understand and apply Excel functions, readers should practice them in over 70 excel exercises from basic to advanced, carefully selected by Mytour for you to quickly grasp the Excel functions you've learned most effectively.

Additionally, you can also learn more about the COUNTIFS function, the conditional statistical function, in the article where we have clearly explained examples and usage to help you understand COUNTIFS faster.

Frequently Asked Questions

What is the purpose of the IFNA function in Excel?

The IFNA function in Excel is designed to check for #N/A errors in a given value or expression. If an error is detected, it returns a specified alternative value; otherwise, it returns the original value.

How does the syntax of the IFNA function look in Excel?

The syntax of the IFNA function is: IFNA(value, value_if_na). Here, 'value' is the expression being checked, and 'value_if_na' is the value returned if the first expression results in an #N/A error.

What examples illustrate the use of the IFNA function in Excel?

Examples of the IFNA function include checking results from VLOOKUP and other expressions. When an error occurs, IFNA will return a specified value to ensure tasks continue smoothly.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]