ReferenceFunctionsInformation Functions
NA
NA: Returns the `#N/A` error value.
Summary
Returns the #N/A error value.
Remarks
NA()is commonly used to mark missing lookup results.- The function takes no arguments.
- The returned value is an error and propagates through dependent formulas.
Examples
Direct N/A
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
#N/A
Detect N/A
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
true
Related functions
FAQ
When should I use NA() intentionally?
Use it to mark missing data so lookups and downstream checks can distinguish absent values from blanks.
Runtime metadata
Category
Information
Signature
NA()Arity
min 0, max 0
Caps
PURE
Source