ISNA Function in Excel

The ISNA function in Excel, tests if an supplied expression or Value returns the Excel #N/A Error, and if so, returns TRUE, If not the function returns FALSE

Syntax of ISNA Function in Excel:

ISNA(value)

Where value argument is the Expression or value to be tested for #N/A Error.

 

Example of ISNA Function in Excel:

Formula:

ISNA function in Excel 1

The above example takes up simple values, Expressions and cell reference as input and returns TRUE only if the resultant value is #N/A, otherwise the function returns FALSE

Result:

ISNA function in Excel 2

previous-small ISNA Function in Excel                                                                                                                next_small ISNA Function in Excel