Microsoft® Excel® 2010 Formulas & Functions Inside Out

Chapter 11. Information Functions

• CELL()

• COUNTBLANK()

• ERROR.TYPE()

• INFO()

• ISBLANK()

• ISERR()

• ISERROR()

• ISEVEN()

• ISLOGICAL()

• ISNA()

• ISNONTEXT()

• ISNUMBER()

• ISODD()

• ISREF()

• ISTEXT()

• N()

• NA()

• TYPE()

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, ...