NA Function in Google Sheets: Create an intentional unavailable-value error
Learn NA in Google Sheets with explicit inputs, worked scenarios, independently checked expectations and troubleshooting.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: Create an intentional unavailable-value error with NA. The Google NA documentation supplies the contract summarized here.
Syntax
=NA() has no arguments. It produces the actual #N/A error, as documented in Google’s function catalogue. Use it when a test or model needs an unavailable result rather than a numeric substitute.
Worked scenario: a missing observation
A practice sheet has a measurement of 12 in A2 and a measurement that has not arrived in A3. Enter =NA() in A3. Its expected result is #N/A. Keep the reason, such as “sensor reading pending,” in an adjacent note column; NA has no message parameter.
A missing measurement and a measured zero are different facts. Substituting 0 may make a later calculation look complete while changing its meaning. Choose an explicit missing-data policy before replacing the error.
Advanced example: build a small error fixture
Prepare three independent cells:
| Cell | Entry | Expected kind |
|---|---|---|
| A6 | =NA() |
Actual #N/A error |
| A7 | ="#N/A" |
Text containing the same visible characters |
| A8 | 0 |
Number zero |
This fixture is useful when reviewing a workbook’s error handling. A display label is not the error value. Use the existing ISNA guide for the detection contract, IFNA for a selective fallback and ERROR.TYPE for error classification. Those guides already contain wrapping examples; this page supplies the error-producing input rather than repeating their tutorials.
Troubleshooting and limits
- Do not pass a reason string to NA. Store explanatory text separately.
- Quoting #N/A produces text, which is unsuitable when testing actual error handling.
- Do not assume every visible #N/A means an absent lookup key. This function can deliberately create one anywhere.
- This guide makes no chart-gap, aggregation, export or general propagation claim. Test the downstream function or visualization explicitly.
Documentation scope
The catalogue establishes the no-argument contract. The detail page was unavailable during review; no additional behavior has been inferred from it. Existing error-handling coverage supplements this short function guide and is not counted as a new article here.
Availability and version history
Documented in the rolling Google Sheets service. Documentation reviewed October 19, 2026; an introduction date or numbered release was not established. Examples use English function names, decimal points and comma separators; adapt separators to the sheet’s locale.
Verification scope and sources
The official reference establishes the syntax and function-specific contract. Worked values are original, independently derived expectations, not native Google Sheets observations. No account access, UI screenshot or cross-version execution was performed. Native behavior outside the documented scope remains unverified.