Rational
Returns #N/A error to specific cell.
Description
The Excel NA function returns with #N/A error. A value of #N/A error means “no value is available” or “value not available”. The function can be used to highlight empty cells or any missing information of data set.
Syntax
=NA()
Parameters
(Empty parenthesis)
Return Value
#N/A
Key Notes
- The NA function must be with empty parentheses.
- The user can directly enter #N/A.
- Moreover, the NA function is also useful for compatibility with other spreadsheet programs.
Keep Reading Similar Functions:
ISERROR
The Excel ISERROR function check if a specified cell has error value and returns “TRUE” when a cell has an error, and “FALSE” it does not.
ISERR
The ISERR function checks if a specified cell has error value ‘except #N/A’ and returns “TRUE” only if a cell has an error. For example: “=ISERR(#DIV/0!)” return TRUE.
ISNA
The Excel ISNA function checks if a specified cell has #N/A error and returns “TRUE” when a cell has a #N/A error, and “FALSE” it does not.