# Excel Information Functions

This page lists the current, built-in Excel Information Functions. These functions provide information about the content, formatting and location of cells in an Excel spreadsheet.

In the tables below, the Excel Information functions have been grouped into categories, to help you to find the function you need. Selecting a function name will take you to a full description of the function with examples of use.

Note that some of the Information functions were only introduced in Excel 2013 and so are not available in earlier versions of Excel.

## Excel Information Functions List

 Error Information Functions ISERROR Tests if an initial supplied value (or expression) returns an error and if so, returns TRUE; Otherwise returns FALSE ISERR Tests if an initial supplied value (or expression) returns an error (EXCEPT for the #N/A error) and if so, returns TRUE; Otherwise returns FALSE ISNA Tests if an initial supplied value (or expression) returns the Excel #N/A error and if so, returns TRUE; Otherwise returns FALSE ERROR.TYPE Tests a supplied value and returns an integer relating to the supplied value's error type Numerical Information Functions ISNUMBER Tests if a supplied value is a number, and if so, returns TRUE; Otherwise, returns FALSE. ISEVEN Tests if a supplied number (or expression) is an even number, and if so, returns TRUE; Otherwise, returns FALSE. ISODD Tests if a supplied number (or expression) is an odd number, and if so, returns TRUE; Otherwise, returns FALSE. N Converts a non-number value to a number, a date to a serial number, the logical value TRUE to 1 and all other values to 0 Function Returning a Constant Value NA Returns the Excel #N/A error
 Other Data Type Functions ISBLANK Tests if a supplied cell is blank (empty), and if so, returns TRUE; Otherwise, returns FALSE ISLOGICAL Tests if a supplied value is a logical value, and if so, returns TRUE; Otherwise, returns FALSE ISTEXT Tests if a supplied value is text, and if so, returns TRUE; Otherwise, returns FALSE ISNONTEXT Tests if a supplied value is text, and if it is NOT, returns TRUE; Otherwise, returns FALSE ISREF Tests if a supplied value is a reference, and if so, returns TRUE; Otherwise, returns FALSE ISFORMULA Tests if a supplied cell contains a formula and if so, returns TRUE; Otherwise, returns FALSE (New in Excel 2013) TYPE Returns information about the data type of a supplied value General Information Functions CELL Returns information about the contents, formatting or location of a given cell SHEET Returns the sheet number relating to a supplied reference (New in Excel 2013) SHEETS Returns the number of sheets in a reference (New in Excel 2013) INFO Returns information about the current operating environment

Further details of each of the Excel Information functions are provided on the Microsoft Office Website.