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:


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


Example of ISNA Function in Excel:


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


ISNA function in Excel 2

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