ISNA Function - Excel
Overview
The ISNA function in Excel is a useful tool for checking if a specified value or expression results in the “#N/A” (Not Available) error. This function returns a TRUE value result when the specified value or expression is equal to “#N/A” and returns a FALSE value result when it does not.
Example:
=ISNA(C2)
Syntax:
=ISNA(value)
value: This is the value or reference to the cell or expression you want to check for the #N/A error.
TRUE Example
In this example, the ISNA function returns the TRUE value because C2 equals “#N/A” which is a “#N/A” (Not Available) error.
FALSE Example
In this example, the ISNA function returns the FALSE value because C2 equals “Apple” which is not a “#N/A” (Not Available) error.
