ISNA

Returns TRUE if a value is the error ‘#NA’ and FALSE otherwise.

Sample Usage

ISNA(C5)

Syntax

ISNA(value)

• value - The value to be checked.
  
  

Examples

ISNA(C5) evaluates to TRUE if the cell C5 contains the ‘#NA’ error.

Notes

• ISNA returns TRUE on '#N/A' errors while ISERROR returns TRUE on all errors.