The Excel NA Function

Related Function:
Isna Function

Function 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 NA function takes no arguments and therefore, the syntax is simply:


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

NA Function Example

1 =NA()
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, for further information on the Excel NA function, see the Microsoft Office website.