Information Functions
- 2 minutes to read
This document briefly describes information functions implemented in the Spreadsheet.
Name | Description | Syntax |
|---|---|---|
CELL | Returns information about the formatting, location, or content of a cell. | CELL(info_type, [reference]) |
ERROR.TYPE | Returns a number corresponding to one of the error values. | ERROR.TYPE(value) |
INFO | Returns information about the current operating environment. | INFO(type_text) |
ISBLANK | Tests if the value is a reference to an empty cell. | ISBLANK(value) |
ISERR | Tests if the value or expression returns an error. | ISERR(value) |
ISERROR | Tests if the value or expression returns an error, except for the #N/A error. | ISERROR(value) |
ISEVEN | Tests if the number is even. | ISEVEN(value) |
ISFORMULA | Tests if the refrenced cell contains formula. | ISFORMULA(reference) |
ISLOGICAL | Tests if the value is a logical value. | ISLOGICAL(value) |
ISNA | Tests if the value or expression returns the #N/A error. | ISNA(value) |
ISNONTEXT | Tests if the value or expression is text. | ISNONTEXT(value) |
ISNUMBER | Tests if the value or expression is a number. | ISNUMBER(value) |
ISODD | Tests if the number is odd. | ISODD(value) |
ISREF | Tests if the value is a reference. | ISREF(value) |
ISTEXT | Tests if the value or expression is text. | ISTEXT(value) |
N | Returns a value converted to a number. | N(value) |
NA | Returns the error value #N/A. | NA() |
SHEET | Returns the sheet number of the referenced sheet. | SHEET(value) The value parameter is optional. It is the name of a sheet or a reference for which to obtain the sheet number. If the value is omitted, the number of the sheet that contains the function is returned. |
SHEETS | Returns the number of sheets in a reference. | SHEETS(reference) The reference parameter is optional. If the parameter is omitted, the number of sheets in the workbook that contains the function is returned. |
TYPE | Returns the type of value. | TYPE(value) |