Syntax
ISNA(value)- value
- The cell, value or formula to check, usually a lookup.
Examples
D1=ISNA(MATCH("Kiwi",A2:A4,0))
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Fruit | Price | TRUE | |
| 2 | Apple | 0.5 | ||
| 3 | Banana | 0.25 | ||
| 4 | Cherry | 3 |
D1=IF(ISNA(MATCH("Banana",A2:A4,0)),"Not on the list","On the list")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Fruit | Price | On the list | |
| 2 | Apple | 0.5 | ||
| 3 | Banana | 0.25 | ||
| 4 | Cherry | 3 |
B1=ISNA(1/0)
| A | B | |
|---|---|---|
| 1 | FALSE |
Questions
Why use ISNA instead of ISERROR?
ISNA reacts only to
What is the difference between ISNA and IFNA?
ISNA returns TRUE or FALSE. IFNA returns a value of your choice instead of