ExcelFlux

ISNA function

TRUE if the value is the #N/A error value.

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

Distinguish a missing exact match from other error types.

A worked example from the workbook

RowAB
6InputComparison
722
855
997
Record 1
=ISNA(MATCH(A7,$B$7:$B$9,0))

Expected resultFALSE

See the inputs and instructions for all 3 examples

Copyable formulas

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

Expected result

TRUE

Worked examples

Distinguish a missing exact match from other error types.

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 B
6 Input Comparison
7 2 2
8 5 5
9 9 7
Case Formula Expected result
Record 1 =ISNA(MATCH(A7,$B$7:$B$9,0)) FALSE
Record 2 =ISNA(MATCH(A8,$B$7:$B$9,0)) FALSE
Record 3 =ISNA(MATCH(A9,$B$7:$B$9,0)) TRUE
Microsoft Excel reference