List of Excel ‘Information Functions’ in Office 365!!
Tags: excelfunctions, informationfunctions, excel, excel365tutorials
Published: 2020-08-21 16:59:20

---
title: List of Excel ‘Information Functions’ in Office 365!!
published: true
date: 2020-08-18 07:47:32 UTC
tags: ExcelFunctions,InformationFunctions,Excel,Excel365Tutorials
canonical_url: https://geekexcel.com/list-of-excel-information-functions-in-office-365/
---

## Excel Information Functions:

This page shows the **list of built-in Information Functions in Excel**.

Excel Information functions are used to obtain information about the worksheets and their contents. You can get details like whether a cell has an error, the current row number, etc.

Click on a function name or read more link to know the complete description of that function with examples.

Note: Excel version is specified in some functions that indicate the introduction of that particular function in Excel. For example, 2013 indicates that the function will be available in Excel 2013 and all the newest versions.

| **S.No** | **Function** | **Explanation & Syntax** | **Read More** |
| 1 | [**CELL Function**](https://geekexcel.com/use-cell-function-in-microsoft-excel-365-simple-methods/) | Returns information about a cell in a worksheet.
```
=CELL(info\_type, [reference])
```
 | [**Read More about CELL Function**](https://geekexcel.com/use-cell-function-in-microsoft-excel-365-simple-methods/) |
| 2 | [**ERROR.TYPE Function**](https://geekexcel.com/how-to-use-error-type-function-in-microsoft-excel-365/) | Returns a number that corresponds to a specific error value.
```
=ERROR.TYPE(error\_val)
```
 | [**Read More about ERROR.TYPE Function**](https://geekexcel.com/how-to-use-error-type-function-in-microsoft-excel-365/) |
| 3 | [**INFO Function**](https://geekexcel.com/use-info-function-in-microsoft-excel-365-simple-methods/) | Returns information about the current operating environment.
```
=INFO(type\_text)
```
 | [**Read More about INFO Function**](https://geekexcel.com/use-info-function-in-microsoft-excel-365-simple-methods/) |
| 4 | [**ISBLANK Function**](https://geekexcel.com/how-to-use-isblank-function-in-microsoft-excel-365/) | Returns TRUE when a cell contains is empty, and FALSE when a cell contains any text or not an empty case.
```
=ISBLANK(value)
```
 | [**Read More about ISBLANK Function**](https://geekexcel.com/how-to-use-isblank-function-in-microsoft-excel-365/) |
| 5 | [**ISERR Function**](https://geekexcel.com/different-ways-to-iserr-function-in-excel-365/) | Returns TRUE for any error type except the #N/A error.
```
=ISERR(value)
```
 | [**Read More about ISERR Function**](https://geekexcel.com/different-ways-to-iserr-function-in-excel-365/) |
| 6 | [**ISERROR Function**](https://geekexcel.com/how-to-use-iserror-function-in-microsoft-excel-365/) | Returns TRUE for any error type excel generates, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!
```
=ISERROR(value)
```
 | [**Read More about ISERROR Function**](https://geekexcel.com/how-to-use-iserror-function-in-microsoft-excel-365/) |
| 7 | [**ISEVEN Function**](https://geekexcel.com/steps-to-use-iseven-function-in-microsoft-excel-365-simple-way/) | Returns TRUE when a numeric value is even, and FALSE for odd numbers.
```
=ISEVEN(value)
```
 | [**Read More about ISEVEN Function**](https://geekexcel.com/steps-to-use-iseven-function-in-microsoft-excel-365-simple-way/) |
| 8 | [**ISFORMULA Function**](https://geekexcel.com/use-isformula-function-in-microsoft-excel-365-simple-methods/) (2013) | Returns TRUE when a cell contains a formula or else it returns FALSE.
```
=ISFORMULA(reference)
```
 | [**Read More about ISFORMULA Function**](https://geekexcel.com/use-isformula-function-in-microsoft-excel-365-simple-methods/) |
| 9 | [**ISLOGICAL Function**](https://geekexcel.com/use-islogical-function-in-microsoft-excel-365-in-easy-ways/) | Returns TRUE when a cell contains the logical values ie., **TRUE or FALSE,**  and returns  **FALSE** for cells that contain any other value, including empty cells.
```
=ISLOGICAL(value)
```
 | [**Read More about ISLOGICAL Function**](https://geekexcel.com/use-islogical-function-in-microsoft-excel-365-in-easy-ways/) |
| 10 | [**ISNA Function**](https://geekexcel.com/how-to-use-isna-function-in-microsoft-excel-365/) | Returns TRUE when a cell contains the #N/A error and FALSE for any other value, or any other error type.
```
=ISNA(value)
```
 | [**Read More about ISNA Function**](https://geekexcel.com/how-to-use-isna-function-in-microsoft-excel-365/) |
| 11 | [**ISNONTEXT Function**](https://geekexcel.com/isnontext-function-in-microsoft-excel-365-how-to-use/) | Returns TRUE for any non-text value and blank cells, and for cells with formulas that return non-text results.
```
=ISNONTEXT(value)
```
 | [**Read More about ISNONTEXT Function**](https://geekexcel.com/isnontext-function-in-microsoft-excel-365-how-to-use/) |
| 12 | [**ISNUMBER Function**](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/) | Returns TRUE when a cell contains a number, or else it returns FALSE.
```
=ISNUMBER(value)
```
 | [**Read More about ISNUMBER Function**](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/) |
| 13 | [**ISODD Function**](https://geekexcel.com/use-isodd-function-in-microsoft-excel-365-simple-methods/) | Returns TRUE when a numeric value is odd, and FALSE for even numbers.
```
=ISODD(value)
```
 | [**Read More about ISODD Function**](https://geekexcel.com/use-isodd-function-in-microsoft-excel-365-simple-methods/) |
| 14 | [**ISREF Function**](https://geekexcel.com/how-to-use-isref-function-in-microsoft-excel-365/) | Returns TRUE when a cell contains a reference or else it returns FALSE.
```
=ISREF(value)
```
 | [**Read More about ISREF Function**](https://geekexcel.com/how-to-use-isref-function-in-microsoft-excel-365/) |
| 15 | [**ISTEXT Function**](https://geekexcel.com/use-istext-function-in-microsoft-excel-365-in-easy-ways/) | Returns TRUE when a cell contains a text or else it returns FALSE.
```
=ISTEXT(value)
```
 | [**Read More about ISTEXT Function**](https://geekexcel.com/use-istext-function-in-microsoft-excel-365-in-easy-ways/) |
| 16 | [**N Function**](https://geekexcel.com/use-n-function-in-microsoft-excel-365-simple-methods/) | Converts the non-number values to numbers, Dates to serial numbers, TRUE to 1, anything else to 0.
```
=N(value)
```
 | [**Read More about N Function**](https://geekexcel.com/use-n-function-in-microsoft-excel-365-simple-methods/) |
| 17 | [**NA Function**](https://geekexcel.com/how-to-use-excel-na-function-in-office-365-with-examples/) | Returns **#N/A**  Error value.
```
=NA()
```
 | [**Read More about NA Function**](https://geekexcel.com/how-to-use-excel-na-function-in-office-365-with-examples/) |
| 18 | [**SHEET Function**](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/) (2013) | Return the index number of the sheet (reference sheet)in Excel.
```
=SHEET([value])
```
 | [**Read More about SHEET Function**](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/) |
| 19 | [**SHEETS Function**](https://geekexcel.com/use-proper-function-in-microsoft-excel-2013-simple-methods/) (2013) | Returns the number of sheets in a given reference.
```
=SHEETS([reference])
```
 | [**Read More about SHEETS Function**](https://geekexcel.com/use-proper-function-in-microsoft-excel-2013-simple-methods/) |
| 20 | [**TYPE Function**](https://geekexcel.com/how-to-use-excel-type-function-in-office-365-with-examples/) | Return a type of value in Excel.
```
=TYPE(value)
```
 | [**Read More about TYPE Function**](https://geekexcel.com/how-to-use-excel-type-function-in-office-365-with-examples/) |

The above list of Information functions in Excel with its explanation and syntax assists you to know all Information functions clearly. Don’t forget to share your **valuable queries** in the below section. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning with us!!