• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint

### Getting Data with Information Functions

Excel's information functions return data concerning cells, worksheets, and formula results. Table 8.2 lists all the information functions.

##### Table 8.2. Excel's Information Functions
FunctionDescription
CELL(info_type,[reference])Returns information about various cell attributes, including formatting, contents, and location
ERROR.TYPE(error_val)Returns a number corresponding to an error type
INFO(type_text)Returns information about the operating system and environment
ISBLANK(value)Returns TRUE if the value is blank
ISERR(value)Returns TRUE if the value is any error value except #NA
ISERROR(value)Returns TRUE if the value is any error value
ISEVEN(number)Returns TRUE if the value is any error value
ISEVEN(number)Returns TRUE if the number is even (this is an Analysis ToolPak function)
ISLOGICAL(value)Returns TRUE if the value is a logical value
ISNA(value)Returns TRUE if the value is the #NA error value
ISNONTEXT(value)Returns TRUE if the value is not text
ISNUMBER(value)Returns TRUE if the value is a number
ISODD(number)Returns TRUE if the number is odd (this is an Analysis ToolPak function)
ISREF(value)Returns TRUE if the value is a reference
ISTEXT(value)Returns TRUE if the value is text
N(value)Returns the value converted to a number (a serial number if value is a date, 1 if value is TRUE, 0 if value is any other non-numeric; note that N() exists only for compatibility with other spreadsheets and is rarely used in Excel)
NA()Returns the error value #NA
TYPE(value)Returns a number that indicates the data type of the value: 1 for a number, 2 for text, 4 for a logical value, 8 for a formula, 16 for an error, or 64 for an array

PREVIEW

Not a subscriber?

Start A Free Trial

• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint