# Information Functions

## Content

Spread provides the following information functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [ERRORTYPE](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ERRORTYPE) | This function returns a number corresponding to one of the error values. |
| [ISBLANK](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISBLANK) | This function tests whether a value, an expression or contents of a referenced cell is empty. |
| [ISERR](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISERR) | This function, Is Error Other Than Not Available, tests whether a value, an expression or contents of a referenced cell has an error other than not available (#N/A). |
| [ISERROR](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISERROR) | This function, Is Error of Any Kind, tests whether a value, an expression or contents of a referenced cell has an error of any kind. |
| [ISEVEN](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISEVEN) | This function, Is Number Even, tests whether a value, an expression or contents of a referenced cell is even. |
| [ISFORMULA](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISFORMULA) | This function tests whether contains a formula of a referenced cell. |
| [ISLOGICAL](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISLOGICAL) | This function tests whether a value, an expression or the contents of a referenced cell is a logical (Boolean) value. |
| [ISNA](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISNA) | This function, Is Not Available, tests whether a value, an expression or contents of a referenced cell has the not available (#N/A) error value. |
| [ISNONTEXT](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISNONTEXT) | This function tests whether a value, an expression or contents of a referenced cell has any data type other than text. |
| [ISNUMBER](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISNUMBER) | This function tests whether a value, an expression or contents of a referenced cell has numeric data. |
| [ISODD](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISODD) | This function, Is Number Odd, tests whether a value, an expression or contents of a referenced cell has numeric data. |
| [ISREF](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISREF) | This function, Is Reference, tests whether a value, an expression or contents of a referenced cell is a reference to another cell. |
| [ISTEXT](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/ISTEXT) | This function tests whether a value, an expression or contents of a referenced cell has text data. |
| [N](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/N) | This function returns a value converted to a number. |
| [NA](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/NA) | This function returns the error value #N/A which means not available. |
| [SHEET](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/SHEET) | This function returns the sheet number of the reference sheet. |
| [SHEETS](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/SHEETS) | This function returns the number of sheets in a reference. |
| [TYPE](/spreadjs/docs/v17/formulareference/FormulaFunctions/information-functions/TYPE) | This function returns the type of value. |