Syntax
NA()
| Parameter | Description |
|---|
Examples
Mark missing data
Formula
=IF(A1="", NA(), A1)
Returns #N/A for blank cells instead of leaving them as zero. Charts will skip #N/A points, creating gaps in line charts where data is missing.
Placeholder in data
Formula
=NA()
Entered directly in a cell to indicate that the data is not yet available. Downstream formulas can use ISNA to detect this.
Force chart gaps
Formula
=IF(B2=0, NA(), B2)
Converts zero values to #N/A so line charts show gaps instead of dipping to zero. Useful when zero means "no data" rather than "zero quantity."
Common Errors
#N/A
This IS the error value. That's the entire purpose of the function — to produce #N/A deliberately.
Tips
Charts skip #N/A
The main reason to use NA() is for charting. Line charts connect through blanks but skip #N/A, creating clean gaps where data is missing.
Pair with ISNA or IFNA
Use ISNA to detect NA values in formulas. =IFNA(A1, 0) replaces #N/A with 0 when you need a numeric fallback downstream.
Better than blank for missing data
Blank cells are ambiguous (forgotten? zero? not applicable?). NA() explicitly communicates "this data is intentionally missing."
Try NA in Viztab
Import your data and use NA with 370+ other formulas. No signup required.
Open Viztab