What is IFNA Function in MS Excel?

This is a built-in function in Excel and it can also be used as a worksheet function. This function in Excel returns an alternate value that is specified by the user if the result of the formula is an error #N/A. This function comes under the category of logical functions in MS Excel.

Purpose of IFNA Function in Excel

The main purpose of the IFNA function in MS Excel is to track and manage the #N/A errors. A normal result is given when there is no error. In case of an error, the IFNA function will give a #N/A error as a result. This is an efficient way to track and manage the #N/A errors. It does not track other errors nor does it manage other errors.

Syntax of IFNA Function

The syntax of the IFNA function is written in the following way.

=IFNA (value, value_if_na)

Arguments

There are two arguments for the IFNA function. These arguments are described below.

Value: this is the value, reference, or formula which has to be checked for errors.

Value_if_na: this is the value that is returned in case of a #N/A error.

Examples

=IFNA (VLOOKUP (E5, xtable, 2, 0), “Not found”)

In this example, the IFNA function is used in combination with the VLOOKUP function. E5 is the VLOOKUP value. If this value is found in the range named ‘xtable’ then a normal value is returned. If the value is not found then #N/A error will occur.