ExcelFlux

NA function

the error value #N/A.

Information

Where can you use it?

Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.

Scenario in the workbook

Generate and catch the specific #N/A marker. IF converts the test into a visible result.

A worked example from the workbook

RowA
6Trial
71
82
93
Record 1
=IF(ISNA(NA()),A7,0)

Expected result1

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=NA()
Turkish Excel · tr-TR
=YOKSAY()

Expected result

#N/A

Worked examples

Generate and catch the specific #N/A marker. IF converts the test into a visible result.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Trial
7 1
8 2
9 3
Case Formula Expected result
Record 1 =IF(ISNA(NA()),A7,0) 1
Record 2 =IF(ISNA(NA()),A8,0) 2
Record 3 =IF(ISNA(NA()),A9,0) 3
Microsoft Excel reference