CELL |
Get information about a cell |
info_typereference |
ERROR.TYPE |
Test for a specific error value |
error_val |
INFO |
Get information about current environment |
type_text |
ISBLANK |
Test if a cell is empty |
value |
ISERR |
Test for any error but #N/A |
value |
ISERROR |
Test for any error |
value |
ISEVEN |
Test if a value is even |
value |
ISFORMULA |
Test if cell contains a formula |
reference |
ISLOGICAL |
Test if a value is logical |
value |
ISNA |
Test for the #N/A error |
value |
ISNUMBER |
Test for numeric value |
value |
ISODD |
Test if a value is odd |
value |
ISREF |
Test for a reference |
value |
ISTEXT |
Test for a text value |
value |
N |
Convert a value to a number |
value |
NA |
Create an #N/A error |
|
TYPE |
Get the type of value in a cell |
value |