Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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 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 »
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 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 »