How do I use ISNA in Excel?
Use ISNA when you want to check whether a result is #N/A. Enter Value in that order, then add optional arguments when needed.
Excel Function
ISNA
Checks whether value is #N/A error.
ISNA(value)Arguments
value
RequiredEnter an expression such as comparison or calculation.
Practice Preview
Use ISNA to check whether XLOOKUP("Not found",B2:B8,D2:D8) returns #N/A.
Example Table
| # | AValue 1 | BValue 2 | CValue 3 | DResult |
|---|---|---|---|---|
| 2 | 120 | Text | ||
| 3 | 98.5 | 100 | ||
| 4 | 0 | N/A | ||
| 5 | 45 | Test | ||
| 6 | ||||
| 7 | ||||
| 8 |
How to Use (Formula)
=ISNA(XLOOKUP("Not found",B2:B8,D2:D8))Result
TRUE
Practice This Function
ISNA FAQ
Where can I practice ISNA?
Use the "Start Function Practice" button to jump straight into ISNA drills.
What arguments does ISNA use?
The main arguments are Value. Enter them in order.