Advanced Excel - Information Functions

Information functions provide information about the content, formatting and location of cells in an Excel Worksheet.

Information Functions

The following table lists all the Information functions −

S.No.	Function and Description
1	CELL Returns information about the formatting, location, or contents of a cell
2	ERROR.TYPE Returns a number corresponding to an error type
3	INFO Returns information about the current operating environment
4	ISBLANK Returns TRUE if the value is blank
5	ISERR Returns TRUE if the value is any error value except #N/A
6	ISERROR Returns TRUE if the value is any error value
7	ISEVEN Returns TRUE if the number is even
8	ISFORMULA Returns TRUE if there is a reference to a cell that contains a formula
9	ISLOGICAL Returns TRUE if the value is a logical value
10	ISNA Returns TRUE if the value is the #N/A error value
11	ISNONTEXT Returns TRUE if the value is not text
12	ISNUMBER Returns TRUE if the value is a number
13	ISODD Returns TRUE if the number is odd
14	ISREF Returns TRUE if the value is a reference
15	ISTEXT Returns TRUE if the value is text
16	N Returns a value converted to a number
17	NA Returns the error value #N/A
18	SHEET Returns the sheet number of the referenced sheet
19	SHEETS Returns the number of sheets in a reference
20	TYPE Returns a number indicating the data type of a value