• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Working with Logical and Info... > Getting Data with Information Functi...

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


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