Excel ISNA Function
Syntax
=ISNA(value)
Checks if the value, cell reference or formula returns an #N/A error.
Returns TRUE or FALSE
Returns TRUE if the result is #N/A
Examples
| A | B | C | D | E | F | G | H |
| 2 | |||||||
| 3 | Cell references | Returned Values | |||||
| 4 | =VLOOKUP(B4,C6:C12,1) | =ISNA(D4) | TRUE | (vlookup returms an #N/A error) | |||
| 5 | =#REF!*#REF! | =ISNA(D5) | FALSE | ||||
| 6 | cell D6 is blank | =ISNA(D6) | FALSE | ||||
| 7 | 100 | 100 | =+B7=C7 | =ISNA(D7) | FALSE | ||
| 8 | |||||||
| 9 | Formulas | ||||||
| 10 | 12 | 2 | =ISNA(B10/D10) | FALSE | |||
| 11 | 12 | 0 | =ISNA(B11/D11) | FALSE |