Chapter 11. Information Functions

This chapter introduces the Microsoft Excel information functions (see Table 11-1), which return information about the content (text, values, or errors) and the format of cells. For example, the IS() functions allow you to use the IF() function and adjust and combine your calculations depending on the cell content. You can also base conditional formats and validation rules on the returned information. These functions are powerful tools and have many practical uses.

Table 11-1. Overview of the Information Functions

Function	Description
CELL()	Returns information about the format, location, and content of a cell
COUNTBLANK()	Returns the number of empty cells in a range
ERROR.TYPE()	Returns the error value for errors in formulas
INFO()	Returns information to the operating system and Excel
ISBLANK()	Returns `TRUE` if the value passed is empty
ISERR()	Returns `TRUE` if the value passed is an error (not #N/A)
ISERROR()	Returns `TRUE` if the value passed is an error
ISEVEN()	Returns `TRUE` if the number is even
ISLOGICAL()	Returns `TRUE` if the value is a logical value
ISNA()	Returns `TRUE` if the value is the #N/A error
ISNONTEXT()	Returns `TRUE` if the value is not text
ISNUMBER()	Returns `TRUE` if the value is a numeric value
ISODD()	Returns `TRUE` if the number is odd
ISREF()	Returns `TRUE` if the value passed is a valid cell reference
ISTEXT()	Returns `TRUE` if the value is text
N()	Converts a value to a number
NA()	Returns the error value `#N/A`
TYPE()	Returns a number for the data type