Information functions
Information functions tell you what is in a cell: a number, text, an error or nothing at all. They are most useful as checks inside other formulas.
21 functions in this category.
Start here
- SHEET
Returns the position number of a sheet in the workbook.
- TYPE
Returns a code for the kind of data in a value.
- ISNUMBER
Checks whether something is truly numeric, a quick test for text-formatted numbers.
- CELL
Reports facts about a cell such as its address, column, or the workbook path.
- ISNA
Detects the not-available error returned by failed lookups.
- ISBLANK
Checks whether a cell has nothing in it.
All information functions
| Function | What it does | Level | Since | Spills? |
|---|---|---|---|---|
CELL | Reports facts about a cell such as its address, column, or the workbook path. | Advanced | 2007 or earlier | No |
ERROR.TYPE | Turns an error into a code so formulas can respond to a specific kind of error. | Advanced | 2007 or earlier | No |
INFO | Tells you about the operating environment, such as the calculation mode. | Expert | 2007 or earlier | No |
ISBLANK | Checks whether a cell has nothing in it. | Beginner | 2007 or earlier | No |
ISERR | Spots errors other than #N/A. | Advanced | 2007 or earlier | No |
ISERROR | Checks for any error, including #N/A. | Beginner | 2007 or earlier | No |
ISEVEN | Checks whether a whole number is even, handy for alternating rows. | Intermediate | 2007 or earlier | No |
ISFORMULA | Tells you whether a cell contains a formula rather than a typed value. | Intermediate | 2013 | No |
ISLOGICAL | Checks whether a value is a logical. | Intermediate | 2007 or earlier | No |
ISNA | Detects the not-available error returned by failed lookups. | Intermediate | 2007 or earlier | No |
ISNONTEXT | The opposite of ISTEXT. | Intermediate | 2007 or earlier | No |
ISNUMBER | Checks whether something is truly numeric, a quick test for text-formatted numbers. | Beginner | 2007 or earlier | No |
ISODD | Checks whether a whole number is odd. | Intermediate | 2007 or earlier | No |
ISOMITTED | Used inside LAMBDA to detect whether an optional parameter was supplied. | Advanced | 2024 | No |
ISREF | Tests whether something is a reference rather than a plain value. | Advanced | 2007 or earlier | No |
ISTEXT | Checks whether a value is text. | Beginner | 2007 or earlier | No |
N | Converts a value to a number; seen in old formulas and a trick for adding comments. | Advanced | 2007 or earlier | No |
NA | Deliberately returns #N/A so charts skip a point or formulas flag missing data. | Intermediate | 2007 or earlier | No |
SHEET | Returns the position number of a sheet in the workbook. | Advanced | 2013 | No |
SHEETS | Counts the sheets in a workbook or in a 3-D reference. | Advanced | 2013 | No |
TYPE | Returns a code for the kind of data in a value. | Advanced | 2007 or earlier | No |
Other categories
- Lookup and reference functions
43 functions
- Math and trig functions
80 functions
- Logical functions
19 functions
- Text functions
48 functions
- Date and time functions
25 functions
- Statistical functions
111 functions
- Financial functions
56 functions
- Database functions
12 functions
- Engineering functions
54 functions
- Web functions
3 functions
- Compatibility functions
41 functions
- Cube functions
7 functions
- Add-in and automation functions
5 functions