Excel Information Functions

This page lists the current, built-in Excel Information Functions. These functions mainly provide information about the contents of cells, such as data type, although Excel has also included functions that will return information about the formatting and location of cells.

The 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 are new in Excel 2013 and so are not available in earlier versions of Excel.


Excel Information Functions List

Error Information Functions
ISERRORTests if an initial supplied value (or expression) returns an error and if so, returns TRUE; Otherwise returns FALSE
ISERRTests if an initial supplied value (or expression) returns an error (EXCEPT for the #N/A error) and if so, returns TRUE; Otherwise returns FALSE
ISNATests if an initial supplied value (or expression) returns the Excel #N/A error and if so, returns TRUE; Otherwise returns FALSE
ERROR.TYPETests a supplied value and returns an integer relating to the supplied value's error type
Numerical Information Functions
ISNUMBERTests if a supplied value is a number, and if so, returns TRUE; Otherwise, returns FALSE.
ISEVENTests if a supplied number (or expression) is an even number, and if so, returns TRUE; Otherwise, returns FALSE.
ISODDTests if a supplied number (or expression) is an odd number, and if so, returns TRUE; Otherwise, returns FALSE.
NConverts 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
NAReturns the Excel #N/A error
Other Data Type Functions
ISBLANKTests if a supplied cell is blank (empty), and if so, returns TRUE; Otherwise, returns FALSE
ISLOGICALTests if a supplied value is a logical value, and if so, returns TRUE; Otherwise, returns FALSE
ISTEXTTests if a supplied value is text, and if so, returns TRUE; Otherwise, returns FALSE
ISNONTEXTTests if a supplied value is text, and if it is NOT, returns TRUE; Otherwise, returns FALSE
ISREFTests if a supplied value is a reference, and if so, returns TRUE; Otherwise, returns FALSE
ISFORMULATests if a supplied cell contains a formula and if so, returns TRUE; Otherwise, returns FALSE (New in Excel 2013)
TYPEReturns information about the data type of a supplied value
General Information Functions
CELLReturns information about the contents, formatting or location of a given cell
SHEETReturns the sheet number relating to a supplied reference (New in Excel 2013)
SHEETSReturns the number of sheets in a reference (New in Excel 2013)
INFOReturns information about the the current operating environment