- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Information - NA Function
Description
The NA function returns the error value #N/A. #N/A is the error value that means "no value is available." Use NA to mark empty cells. You can also get the same result by simply typing #N/A directly into a Worksheet cell.
By entering NA () or #N/A in cells where you are missing information, you can avoid the problem of unintentionally including empty cells in your calculations. (When a formula refers to a cell containing #N/A, the formula returns the #N/A error value.)
Syntax
NA ( )
Arguments
The NA function syntax has no arguments.
Notes
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.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016