# information functions

ask what a cell holds — type, emptiness, errors.

24 functions.

- [CELL](https://deepcalc.com/functions/cell.md) — information about a cell's formatting, location or contents
- [ERROR.TYPE](https://deepcalc.com/functions/error-type.md) — returns number corresponding to an error type
- [FORMULATEXT](https://deepcalc.com/functions/formulatext.md) — returns formula as a text string
- [INFO](https://deepcalc.com/functions/info.md) — information about the operating environment
- [ISBLANK](https://deepcalc.com/functions/isblank.md) — returns TRUE if value is blank
- [ISDATE](https://deepcalc.com/functions/isdate.md) — true when a value can be read as a date
- [ISEMAIL](https://deepcalc.com/functions/isemail.md) — true when text looks like an email address
- [ISERR](https://deepcalc.com/functions/iserr.md) — returns TRUE if value is any error except #N/A
- [ISERROR](https://deepcalc.com/functions/iserror.md) — returns TRUE if value is any error
- [ISEVEN](https://deepcalc.com/functions/iseven.md) — returns TRUE if number is even
- [ISFORMULA](https://deepcalc.com/functions/isformula.md) — returns TRUE if cell contains a formula
- [ISLOGICAL](https://deepcalc.com/functions/islogical.md) — returns TRUE if value is logical
- [ISNA](https://deepcalc.com/functions/isna.md) — returns TRUE if value is #N/A error
- [ISNONTEXT](https://deepcalc.com/functions/isnontext.md) — returns TRUE if value is not text
- [ISNUMBER](https://deepcalc.com/functions/isnumber.md) — returns TRUE if value is a number
- [ISODD](https://deepcalc.com/functions/isodd.md) — returns TRUE if number is odd
- [ISREF](https://deepcalc.com/functions/isref.md) — returns TRUE if value is a reference
- [ISTEXT](https://deepcalc.com/functions/istext.md) — returns TRUE if value is text
- [ISURL](https://deepcalc.com/functions/isurl.md) — true when text looks like a url
- [N](https://deepcalc.com/functions/n.md) — converts a value to a number
- [NA](https://deepcalc.com/functions/na.md) — returns the error value #N/A
- [SHEET](https://deepcalc.com/functions/sheet.md) — returns sheet number of a reference
- [SHEETS](https://deepcalc.com/functions/sheets.md) — number of sheets in a reference
- [TYPE](https://deepcalc.com/functions/type.md) — returns type of a value as number

## navigate

- [function index](https://deepcalc.com/functions.md)
- [error values](https://deepcalc.com/errors.md) · [concepts](https://deepcalc.com/concepts.md) · [limits](https://deepcalc.com/limits.md)

source: https://deepcalc.com/functions/information-functions