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.

Return to the List of All Built-In Excel Functions
Return to the ExcelFunctions.net Home Page