Google Sheets

NA function in Google Sheets

Returns the "value not available" error, `#N/A`.

=NA()

NA examples

Formulas you'll actually reuse.

Turn blanks into #N/A so a chart skips the point instead of plotting 0:
```
=IF(C2 = "", NA(), C2)
```
Keep a missing lookup as a deliberate #N/A rather than a blank:
```
=IFERROR(VLOOKUP(A2, Prices!A:B, 2, FALSE), NA())
```

NA in Excel

Same name — your formula ports as-is.

Try NA in the playground

Edit the example — nothing to install.

Preloaded with the NA formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.