Excel NA Function

HomeExcel FunctionsExcel NA Function (Example + Sample File)

What is EXCEL NA FUNCTION

The Excel NA Function is listed under Microsoft Excel's Information Functions category. It returns the #N/A value. In simple words, the NA function returns the error value #N/A in the result. The best use of NA function is to get an error when you have empty and missing information in a cell.

How to use it

To learn how to use the N function in Excel, you need to understand its syntax and arguments:

Syntax

NA(value)

Arguments

  • There's no argument in NA.

Notes

  • You can use NA with functions to returns an #N/A error. 

Example

To master the NA function we need to try it out in an example and below is one which you can try out:

In the below example, we have inserted NA function in the cell A1 and it has simply returned #N/A.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.