Information Function

This page lists the current, built-in Excel Information Functions. These functions mainly provide information about the contents of cells, such as data types and properties. There are also functions that provide information on a cell's formatting or location and on the current operating environment.

Note that some of the Information functions listed below are new in Excel 2013 and so are not available in earlier versions of Excel.

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.

Error Information Functions

-

• ERROR.TYPE

  Tests a supplied value and returns an integer relating to the supplied value's error type

• 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

• ISERROR

  Tests if an initial supplied value (or expression) returns an 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

Numerical Information Functions

-

• ISEVEN

  Tests if a supplied number (or expression) is an even number, and if so, returns TRUE; Otherwise, returns FALSE.

• ISNUMBER

  Tests if a supplied value is a 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

Functions 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

General Information Functions

-