This article describes the formula syntax and usage of the NA function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.
Returns the error value #N/A. #N/A is the error value that means "no value is available." Use NA to mark empty cells. By entering #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.)
The NA function syntax has no arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.).
- 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.