Home > Formulas > Info > Topics

# Excel Information Functions Guide

A short guide to the Excel Information functions, including CELL, ERROR.TYPE, INFO, ISFORMULA, SHEET, and many more.

Author: Debra Dalgleish

## Introduction: Excel Information Functions

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 Function

With 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.

### Example - CELL - Number Format

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:

• =CELL("format",C2)

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.

## ERROR.TYPE Function

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

### ISFORMULA Examples

Click the link to read about the Excel ISFORMULA function, to check if a cell contains a formula, in Excel 2013 or later. You'll find examples, videos, and a sample Excel file to download.

### All Excel Information Functions

Below is the full list of all 21 Excel Information Functions, and you can find more information on the Microsoft website.

• Note: Blue links go to the related function page, here on the Contextures site.

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

### Excel Information Functions - 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

## More Excel Functions

CHOOSE

LOOKUP

Lookup - 2 Criteria