Microsoft® Excel® 2010 Formulas & Functions Inside Out

Chapter 9. Logical Functions

• AND()

• FALSE()

• IF()

• IFERROR()

• NOT()

• OR()

• TRUE()

This chapter explains how to use the logical functions such as NOT(), AND(), and OR() in Microsoft Excel. Table 9-1 lists all the logical functions. Other functions, such as TRUE() and FALSE(), are less frequently used. All of these functions return logical values or use them as an integral part of the function. The IF() function evaluates logical expressions and implements appropriate branches. Comparison operators (=, <, >, <=, >=, and <>) are important when evaluating arguments. The IFERROR() function was introduced in Excel 2007.

Table 9-1. Overview of the Logical Functions

Function	Description
AND()	Returns the logical value TRUE if all arguments are true
FALSE()	Returns the ...