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 boolean True or False depending if the value is blank.
ISERRThe boolean True or False depending if the value is an error (not #N/A).
ISERRORThe boolean True or False depending if the value is an error.
ISEVENThe boolean True or False depending if the value is an even number.
ISFORMULA(2013) The boolean True or False depending if the cell contains a formula.
ISLOGICALThe boolean True or False depending if the value is True or False.
ISNAThe boolean True or False depending if the value is #N/A.
ISNONTEXTThe boolean True or False depending if the value is non text.
ISNUMBERThe boolean True or False depending if the value is a number.
ISODDThe boolean True or False depending if the value is an odd number.
ISREFThe boolean True or False depending if the value is a cell reference.
ISTEXTThe boolean 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 boolean True or False depending if the value is blank.
ISERR
The boolean True or False depending if the value is an error (not #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
(2013) 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
(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.

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