NA Function in Google Sheets

Return the

NA Function

The NA function in Google Sheets returns the #N/A error, which indicates that a value is not available.

Syntax

NA()

Examples

  1. Basic Usage

Return the #N/A error:

=NA()

This will output #N/A.

Notes

  • The #N/A error can be useful in marking cells where data is missing or not applicable.
  • Use error-checking functions like IFERROR or IFNA to handle #N/A errors.
  • IFERROR: Return a custom value if a formula results in an error.
  • IFNA: Return a custom value if a formula results in the #N/A error.