ISNA ()
This function tests a cell to determine whether it contains
the error #N/A.
It will show TRUE for #N/A value in the cell.
Best view in desktop mode.
|
|
A |
B |
C |
D |
|
1 |
Values |
Result |
||
|
2 |
1 |
FALSE |
=ISNA(A2) |
|
|
3 |
Welcome |
FALSE |
=ISNA(A3) |
|
|
4 |
#VALUE! |
FALSE |
=ISNA(A4) |
|
|
5 |
14-Jan-21 |
FALSE |
=ISNA(A5) |
|
|
6 |
#N/A |
TRUE |
=ISNA(A6) |
|
|
7 |
#VALUE! |
FALSE |
=ISNA(A7) |
|
|
8 |
The #N/A is generated when a function cannot work properly
because of missing data.
The #N/A can also be typed into a cell by the user to
indicate the cell is currently empty but will be used for data entry in the
future.
The function is normally used with other functions such as
the IF() function.
Syntax
=ISNA (Cell)
Formatting
No
special formatting is needed.
Excel provides numerous formulas for all types of applications, thank you for sharing this. The user guides cover these formulas and their applications, reading these helpful guides can help clear common problems related to Office setup and exploring the features Office offers. Great post.
ReplyDelete