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.