NA

The NA function in Google Sheets returns the "value not available" error, #N/A, without requiring any arguments. It's commonly used as a placeholder to flag missing data or to force downstream formulas to surface an error intentionally. Dive into our comprehensive guide to master its application.

Parameters

This function takes no parameters.

Step-by-Step Tutorial

1. Returning the #N/A error:

   • Example: =NA()
   • Result: #N/A

2. Using NA to flag missing data:

   • Example: =IF(A1="", NA(), A1*2)
   • Result: Returns #N/A if A1 is empty, otherwise doubles the value in A1.

Use Cases and Scenarios

1. Chart Data: Insert #N/A in a data range so Google Sheets charts skip the point instead of plotting it as zero.
2. Data Validation: Mark incomplete records with a clear #N/A flag for later review.
3. Formula Testing: Deliberately trigger an #N/A error to test how other formulas handle error propagation.

Related Functions

• ISNA: Checks whether a value is the #N/A error.
• ISERROR: Checks whether a value is an error.
• ERROR.TYPE: Returns a number corresponding to the error value in a cell.

Related Articles

No related articles available for the NA function.