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:
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:
