Information functions in brief

Basic Description

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.
The functions have been grouped into categories, to help you to find the function you need to perform a specific task. Selecting a function name will take you to a full description of the function with examples of use.

 

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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment