Information Functions
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. |
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. |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top