Information Functions

Back

CELL : Returns information about the formatting, location, or contents of a cell 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
ISERROR : Returns TRUE if the value is any error value
ISEVEN : Returns TRUE if the number is even
ISLOGICAL : Returns TRUE if the value is a logical value
ISNA : Returns TRUE if the value is the #N/A error value
ISNONTEXT : Returns TRUE if the value is not text
ISNUMBER : Returns TRUE if the value is a number
ISODD : Returns TRUE if the number is odd
ISREF : Returns TRUE if the value is a reference
ISTEXT : Returns TRUE if the value is text
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