Information Functions
CELL | The text string indicating information about a cell. |
DETECTLANGUAGE | (2024) 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. |
TYPE | The number indicating the data type of the value. |
CELL The text string indicating information about a cell. |
DETECTLANGUAGE (2024) 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. |
TYPE The number indicating the data type of the value. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top