Information Functions

CELLThe text string indicating information about a cell.
ERROR.TYPEThe number corresponding to a particular error value in a cell.
INFOThe text string returning useful information about the environment.
ISBLANKThe value True or False depending if the value is blank.
ISERRThe value True or False depending if the value is an error (not #N/A).
ISERRORThe value True or False depending if the value is an error.
ISEVENThe value True or False depending if the value is an even number.
ISFORMULA(2013) The value True or False depending if the cell contains a formula.
ISLOGICALThe value True or False depending if the value is True or False.
ISNAThe value True or False depending if the value is #N/A.
ISNONTEXTThe value True or False depending if the value is non text.
ISNUMBERThe value True or False depending if the value is a number.
ISODDThe value True or False depending if the value is an odd number.
ISREFThe value True or False depending if the value is a cell reference.
ISTEXTThe value True or False depending if the value is text.
NThe value converted to a number.
NAThe error value #N/A.
SHEET(2013) The sheet number of the referenced sheet.
SHEETS(2013) The number of sheets in a reference.
TYPEThe number indicating the data type of the value.
CELL
The text string indicating information about a cell.
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 value True or False depending if the value is blank.
ISERR
The value True or False depending if the value is an error (not #N/A).
ISERROR
The value True or False depending if the value is an error.
ISEVEN
The value True or False depending if the value is an even number.
ISFORMULA
(2013) The value True or False depending if the cell contains a formula.
ISLOGICAL
The value True or False depending if the value is True or False.
ISNA
The value True or False depending if the value is #N/A.
ISNONTEXT
The value True or False depending if the value is non text.
ISNUMBER
The value True or False depending if the value is a number.
ISODD
The value True or False depending if the value is an odd number.
ISREF
The value True or False depending if the value is a cell reference.
ISTEXT
The value True or False depending if the value is text.
N
The value converted to a number.
NA
The error value #N/A.
SHEET
(2013) The sheet number of the referenced sheet.
SHEETS
(2013) The number of sheets in a reference.
TYPE
The number indicating the data type of the value.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top