Excel Spreadsheets Information Functions (17)

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