This post will guide you how to use Excel NA function with syntax and examples in Microsoft excel.
The Excel NA function returns the #N/A error value. And the #N/A is the error value that means “no values is available”. And the #N/A error value will be produced when a formula is not able to find a valid value.
The NA function is a build-in function in Microsoft Excel and it is categorized as an Information Function.
The NA function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.
The syntax of the NA function is as below:
= NA ( )
There are no parameters or arguments for the NA function.
- You must include the empty parentheses with the function name. Otherwise, Microsoft Excel will not recognize it as a function.
- You can also type the value #N/A directly into a cell. The NA function is provided for compatibility with other spreadsheet programs.