The Excel ISNA Function

Related Functions:
ISERR
ISERROR
Excel #N/A Error

The Excel #N/A error is produced when a value is not available to your formula.

For example, if the Vlookup function is asked to look up the value '10' in a spreadsheet column, but there is no cell containing the value 10, the function will, instead, return the #N/A error.

Function 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 syntax of the function is:

ISNA( value )

Where the value argument is the expression or value to be tested.

Isna Function Examples

The following spreadsheet shows the Excel Isna function, used to test different values and expressions.

Formulas:
AB
1 =ISNA( 536 )
2 =ISNA( "text" )
3 =ISNA( #N/A )
4 =ISNA( 10+5 )
5 =ISNA( VLOOKUP( 10, A1:A7, 1, 0 ) )
6#N/A=ISNA( A6 )
7#DIV/0!=ISNA( A7 )
8 =ISNA( A8 )
Results:
AB
1 FALSE
2 FALSE
3 TRUE
4 FALSE
5 TRUE
6#N/ATRUE
7#DIV/0!FALSE
8 FALSE

The above examples use different argument types, including:

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

Note also that, in the above examples:

• Although the expression in cell A7 is an error, this is not the #N/A error, so the Isna function in cell B7 returns FALSE.
• 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.

For further information and examples of the Excel 'Is' functions, see the Microsoft Office website.