|
Home > Formulas > Info > Topics Excel Information Functions GuideA short guide to the Excel Information functions, including CELL, ERROR.TYPE, INFO, ISFORMULA, SHEET, and many more.
Author: Debra Dalgleish |
Excel includes a rich set of information functions that can transform your raw data into meaningful patterns. Start with helpful Excel functions like CELL, INFO, and ERROR.TYPE.
Next, explore other information functions like SHEET and SHEETS, ISFORMULA, and more.
This guide will give you a quick overview of Excel's information functions, and will lead you to in-depth articles, where you'll find detailed examples, step-by-step videos, and sample files to download.
CELL and INFO FunctionWith the CELL function in Excel, you can get 13 different types of information about a specific cell on the worksheet. For example, get the cell's address, number format, or sheet name. To see a quick overview of the CELL function's uses, watch this short video. There is a CELL example below the video, and links to more count function examples. |
With "format" as its info_type argument, you can use the CELL function to show the number format of a cell.
For example, in the screen shot below, cell B7 has the General number format
In cell C4, the result of the CELL formula is "G", for General:

The Excel INFO function is similar to the CELL function, and it returns 7 different types of information about the current operating environment. For example, get the Excel version, or the current recalculation mode.
Click the link to read more about the Excel CELL and INFO functions. You'll find examples, videos, and sample Excel files to download.
The Excel ERROR.TYPE function can identify specific types of errors, and you can use that information to help with troubleshooting worksheet formulas.

In the video below, I show examples of using the ERROR.TYPE function for formula troubleshooting
Below is the full list of all 21 Excel Information Functions, and you can find more information on the Microsoft website.
To see the full list of Excel Information functions, click on the green check box below. When you're finished, you can click the check box again, to hide the full list
| CELL | Returns a number corresponding to an error type |
| ERROR.TYPE | Returns a number corresponding to an error type |
| INFO | Returns Info about the current operating environment |
| ISBLANK | Returns TRUE if the value is blank |
| ISERR | Returns TRUE if the value is any error value except #N/A |
| ISERROR | Returns TRUE if the value is any error value |
| ISEVEN | Returns TRUE if the number is even |
| ISFORMULA | Returns TRUE if there is a reference to a cell that contains a formula |
| ISLOGICAL | Returns TRUE if the value is a logical value |
| ISNA | Returns TRUE if the value is the #N/A error value |
| ISNONTEXT | Returns TRUE if the value is not text |
| ISNUMBER | Returns TRUE if the value is a number |
| ISODD | Returns TRUE if the number is odd |
| ISOMITTED | Checks whether the value in a LAMBDA is missing and returns TRUE or FALSE |
| ISREF | Returns TRUE if the value is a reference |
| ISTEXT | Returns TRUE if the value is text |
| N | Returns a value converted to a number |
| NA | Returns the error value #N/A |
| SHEET | Returns the sheet number of the referenced sheet |
| SHEETS | Returns the number of sheets in a reference |
| TYPE | Returns a number indicating the data type of a value |
Last updated: July 8, 2025 3:49 PM