Basic Description

The Excel ISNA function tests if an initial supplied expression (or value) returns the Excel #N/A Error, and if so, returns TRUE; Otherwise the function returns FALSE.

The format of the function is :

Where the value argument is the expression or value to be tested. This can be either supplied directly to the function, or can be the name or reference of a cell containing a value or formula.

Isna Function Examples

The following spreadsheet shows several examples of the Excel Isna function.

The above examples use different argument types, including:

• Simple values (see cells B1 - B3)
• Expressions (see cells B4 & B5)
• Cell references (see cells B6 & B7)

Note also that, in the above examples:

• The expression in cell B4, DOES produce an error, but this is not the #N/A error, and so the Isna function returns FALSE.
• In the example in cell B5, the Vlookup function cannot find the value '10' in column A of the spreadsheet, and so returns the #N/A error. Therefore, the Isna function returns TRUE.