Information Functions

CELL(info_type,reference)Returns information about the formatting, location, or contents of a cell.
ERROR.TYPE(error_val)Returns a number corresponding to an error value.
INFO(type_text)Returns information about the current operating environment.
ISBLANK(value)Returns TRUE if the value is blank.
ISERR(value)Returns TRUE if the value is any error value except #N/A.
ISERROR(value)Returns TRUE if the value is any error value.
ISLOGICAL(value)Returns TRUE if the value is a logical value.
ISNA(value) Returns TRUE if the value is the #N/A error value.
ISNONTEXT(value)Returns TRUE if the value is not text.
ISNUMBER(value)Returns TRUE if the value is a number.
ISREF(value)Returns TRUE if the value is a reference.
ISTECT(value)

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.