NA

Returns #N/A error to specific cell in Excel
Returns the error value #N/A

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:

Check if cell refers to an error value in Excel

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.

Read More »
Check if cell refers to any error value except #N/A in Excel

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.

Read More »
Check a cell for #N/A error in Excel

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.

Read More »