Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
NA
NA() takes no arguments and simply returns the #N/A error, which signals that a value is not available. It is used intentionally to leave gaps in chart data series so Excel/Sheets does not interpolate missing points, or to mark placeholder cells that must be filled before a model is complete.
Excel
=IF(A2="",NA(),A2)Google Sheets
=IF(A2="",NA(),A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Month | Sales |
| Jan | 1200 |
| Feb | #N/A |
| Mar | 1500 |
=IF(A2="",NA(),A2)→Jan
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Use NA() with no arguments wherever you need to explicitly mark a value as unavailable.
- 2Charts treat #N/A as a gap, so use =IF(condition,NA(),value) to prevent a chart from connecting missing data points.
- 3Combine with ISNA and IFERROR in dependent formulas to handle the intentional #N/A gracefully downstream.
Need a version for your data?
Try: “Make my line chart show a gap instead of zero when data is missing”