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.

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

Note also that, in the above examples:


Further information and examples of the Excel 'Is' functions are provided on the Microsoft Office website.