The Excel ISNA Function

Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Isna-Function Search this site: Custom Search

Related Functions:  ERROR.TYPE ISERR ISERROR

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 cell, or can be a name or reference for a cell containing a value or formula.

Isna Function Examples

The following spreadsheet shows examples, of the Excel Isna function, used to determine whether a value or expression returns the #N/A error.

The format of the functions are shown in the spreadsheet on the left and the resulting values are shown in the spreadsheet on the right.

Formulas:

Results:

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

Further information and examples of the Excel 'Is' functions can be found on the Microsoft Office website.