information functions
ask what a cell holds — type, emptiness, errors.
| function | signature | what it does | tests |
|---|---|---|---|
| CELL | CELL(info_type, [reference]) | information about a cell's formatting, location or contents | 26 |
| ERROR.TYPE | ERROR.TYPE(error_val) | returns number corresponding to an error type | 1 |
| FORMULATEXT | FORMULATEXT(reference) | returns formula as a text string | — |
| INFO | INFO(type_text) | information about the operating environment | — |
| ISBLANK | ISBLANK(value) | returns TRUE if value is blank | 1 |
| ISERR | ISERR(value) | returns TRUE if value is any error except #N/A | 1 |
| ISERROR | ISERROR(value) | returns TRUE if value is any error | 1 |
| ISEVEN | ISEVEN(number) | returns TRUE if number is even | 1 |
| ISFORMULA | ISFORMULA(reference) | returns TRUE if cell contains a formula | — |
| ISLOGICAL | ISLOGICAL(value) | returns TRUE if value is logical | 1 |
| ISNA | ISNA(value) | returns TRUE if value is #N/A error | 1 |
| ISNONTEXT | ISNONTEXT(value) | returns TRUE if value is not text | 1 |
| ISNUMBER | ISNUMBER(value) | returns TRUE if value is a number | 1 |
| ISODD | ISODD(number) | returns TRUE if number is odd | 1 |
| ISREF | ISREF(value) | returns TRUE if value is a reference | — |
| ISTEXT | ISTEXT(value) | returns TRUE if value is text | 1 |
| N | N(value) | converts a value to a number | 10 |
| NA | NA() | returns the error value #N/A | 1 |
| SHEET | SHEET([value]) | returns sheet number of a reference | 6 |
| SHEETS | SHEETS([reference]) | number of sheets in a reference | 2 |
| TYPE | TYPE(value) | returns type of a value as number | 5 |