The Excel NA Function

Related Function:
Isna Function

Basic Description

The Excel NA function returns the Excel #N/A error. This error message has the meaning '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:

NA()

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


NA Function Example

 Formula:
 A
1=NA()
 Result:
 A
1#N/A

For further 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 is provided on the Microsoft Office website