How to Use the NA Function in Excel

This guide explains how to use NA Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function returns the N / A error value, which means that no values match the search results.

Syntax: NA ()

- The NA () function contains no arguments.

Attention:

- Must enclose parentheses in the function name.

- You can enter the value # N / A immediately in the cell to mark the blank value.

For example:

Determining the return value of the MATCH and VLOOKUP functions is described in the following data table:

- Find the value of the string 'abc' in the data table. In a cell to calculate, enter the formula : = VLOOKUP ("abc", B5: C9,2)

- Press Enter -> return value is:

- The string 'abc' is not in the data table -> the function returns the # N / A error value .

- Similar to the MATCH function -> enter the formula: = MATCH ("1234", B5: C10,0)

- Press Enter -> return value is:

- Similarly copying the formula for the remaining values results:

Above are instructions and some specific examples when using the NA function in Excel.

Good luck!