ISNA

Posted on 18-01-2020 , by: admin , in , 0 Comments

isna

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.

Number Result
1 FALSE  =ISNA(C4)
Hello FALSE  =ISNA(C5)
FALSE  =ISNA(C6)
1-Jan-98 FALSE  =ISNA(C7)
#N/A TRUE  =ISNA(C8)

Leave a comment