Information functions
The 21 information functions in Sheets, with the usual names, arguments and results.
| Function | What it does | Syntax |
|---|---|---|
| CELL | Information about a cell | CELL(info_type, [reference]) |
| ERROR.TYPE | Number of an error type | ERROR.TYPE(error_val) |
| INFO | Information about the environment | INFO(type_text) |
| ISBLANK | TRUE if the cell is empty | ISBLANK(value) |
| ISERR | TRUE if value is an error other than #N/A | ISERR(value) |
| ISERROR | TRUE if value is an error | ISERROR(value) |
| ISEVEN | TRUE if the number is even | ISEVEN(number) |
| ISFORMULA | TRUE if the cell holds a formula | ISFORMULA(reference) |
| ISLOGICAL | TRUE if value is TRUE or FALSE | ISLOGICAL(value) |
| ISNA | TRUE if value is #N/A | ISNA(value) |
| ISNONTEXT | TRUE if the value is not text | ISNONTEXT(value) |
| ISNUMBER | TRUE if value is a number | ISNUMBER(value) |
| ISODD | TRUE if the number is odd | ISODD(number) |
| ISREF | TRUE if the value is a reference | ISREF(value) |
| ISTEXT | TRUE if value is text | ISTEXT(value) |
| N | Value converted to a number | N(value) |
| NA | The #N/A error value | NA() |
| SHEET | Sheet number of a reference | SHEET([value]) |
| SHEETS | Number of sheets | SHEETS([reference]) |
| T | Text of a value, else empty | T(value) |
| TYPE | Type of a value as a number | TYPE(value) |