Information Functions

CELL	The text string indicating information about a cell.
DETECTLANGUAGE	(365) Preview. The language code for the text string provided.
ERROR.TYPE	The number corresponding to a particular error value in a cell.
INFO	The text string returning useful information about the environment.
ISBLANK	The boolean True or False depending if the value is blank.
ISERR	The boolean True or False depending if the value is an error (excluding #N/A).
ISERROR	The boolean True or False depending if the value is an error.
ISEVEN	The boolean True or False depending if the value is an even number.
ISFORMULA	The boolean True or False depending if the cell contains a formula.
ISLOGICAL	The boolean True or False depending if the value is True or False.
ISNA	The boolean True or False depending if the value is #N/A.
ISNONTEXT	The boolean True or False depending if the value is non text.
ISNUMBER	The boolean True or False depending if the value is a number.
ISODD	The boolean True or False depending if the value is an odd number.
ISREF	The boolean True or False depending if the value is a cell reference.
ISTEXT	The boolean True or False depending if the value is text.
N	The value converted to a number.
NA	The error value #N/A.
SHEET	The sheet number of the referenced sheet.
SHEETS	The number of sheets in a reference.
TABLE	(Data Tables) The data table value calculated inside an array formula.
TYPE	The number indicating the data type of the value.

CELL The text string indicating information about a cell.
DETECTLANGUAGE (365) Preview. The language code for the text string provided.
ERROR.TYPE The number corresponding to a particular error value in a cell.
INFO The text string returning useful information about the environment.
ISBLANK The boolean True or False depending if the value is blank.
ISERR The boolean True or False depending if the value is an error (excluding #N/A).
ISERROR The boolean True or False depending if the value is an error.
ISEVEN The boolean True or False depending if the value is an even number.
ISFORMULA The boolean True or False depending if the cell contains a formula.
ISLOGICAL The boolean True or False depending if the value is True or False.
ISNA The boolean True or False depending if the value is #N/A.
ISNONTEXT The boolean True or False depending if the value is non text.
ISNUMBER The boolean True or False depending if the value is a number.
ISODD The boolean True or False depending if the value is an odd number.
ISREF The boolean True or False depending if the value is a cell reference.
ISTEXT The boolean True or False depending if the value is text.
N The value converted to a number.
NA The error value #N/A.
SHEET The sheet number of the referenced sheet.
SHEETS The number of sheets in a reference.
TABLE (Data Tables) The data table value calculated inside an array formula.
TYPE The number indicating the data type of the value.