The Excel NA Function

Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Na-Function Search this site: Custom Search

Related Function:  Isna Function

Basic Description

The Excel NA function returns the Excel #N/A error. This error message denotes 'value not available' and is produced when an Excel Formula is unable to find a value that it needs.

The function takes no arguments and therefore, the format is simply:

Note that you can also get the same result by simply typing #N/A directly into a worksheet cell.

For more details on the Excel #N/A error, and other Excel error types, go to the Excel Formula Errors page.

Also, further information on the Excel NA function can be found on the Microsoft Office website