The Excel ISNA Function

Related Functions:
ERROR.TYPE
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. 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:
Examples of use of the Excel Isna Function
 Results:
Excel Isna Function Results

The above examples use different argument types, including:

Note also that, in the above examples:


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

Return to the Excel Information Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net