Excel

NA function in Excel

Returns the error value #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())
```

Same name — your formula ports as-is.

Edit the example — nothing to install.

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

Loading the editor…

More ways Excel gets this done.