The Excel NA Function

Related 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:

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

Return to the Excel Information Functions Page
Return to the List of All Built-In Excel Functions