.

ISNA Function Dictionary

Function Dictionary Function Examples Function Categories

ISNA            
 
Number Result
1 FALSE  =ISNA(C4)
Hello FALSE  =ISNA(C5)
  FALSE  =ISNA(C6)
1-Jan-98 FALSE  =ISNA(C7)
#N/A TRUE  =ISNA(C8)
What Does It Do?            
This function tests a cell to determine whether it contains the Not Available error #N/A.
The #N/A is generated when a function cannot work properly because of missing data.
The #N/A can also be typed in to 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(CellToTest)
Formatting            
No special formatting is needed.

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download