NA function
NA deliberately returns the #N/A error. Use it to flag missing data or to make a chart skip a point instead of plotting a zero.
Example
A
B
C
D
1
#N/A
2
3
Syntax
NA()
NA takes no arguments.
Returns: The #N/A error.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ISNA(NA()) | TRUE | Detected |
=COUNT(1,NA()) | 1 | COUNT skips? |
=NA() | #N/A | Error value |
=NA()+1 | #N/A | Propagates |
Watch out for
- Takes no arguments but needs the parentheses.
Where it works
- Excel
- NA is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .