NA()
Syntax. NA()
Definition. This function returns the #N/A error if a value doesn’t exist.
Arguments. This function does not use arguments.
Background. Although this function doesn’t use arguments, you have to enter the parentheses; otherwise, Excel recognizes the function as text.
Similar to the TRUE() and FALSE() functions, in which you can enter the corresponding logical values, you can enter the #N/A error value for the NA() function to get the same result. The NA() function is provided for compatibility with other spreadsheet applications.
You can use this function or the result to explicitly mark empty cells. This ensures that empty cells are not used for other calculations. Formulas referring to these cells return the same error value. You ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
