Functions |
What it Does |
ISERROR |
Returns TRUE if the value is any
error value |
CELL |
Returns information about the
formatting, location, or contents of a cell |
ISNUMBER |
Returns TRUE if the value is a
number |
ISTEXT |
Returns TRUE if the value is
text |
ERROR.TYPE |
Returns a number corresponding
to an error type |
INFO |
Returns information about the
current operating environment |
ISBLANK |
Returns TRUE if the
value is BLANK |
ISERR |
Returns TRUE if the value is any
error value except #N/A |
ISEVEN |
Returns TRUE if the number is
even |
ISLOGICAL |
Returns TRUE if the value is a
logical value |
ISNONTEXT |
Returns TRUE if the value is not
text |
ISNA |
Returns TRUE if the value is the
#N/A error value |
ISODD |
Returns TRUE if the value is odd |
ISREF |
Returns TRUE if the value is a
reference |
N |
Returns a value converted to a
number |
NA |
Returns the error value #N/A |
TYPE |
Returns a number indicating the
data type of a value |