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

ISNA( value )

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


Isna Function Examples

The following spreadsheets show several examples of the Excel Isna function.

 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.