Special Edition Using® Microsoft® Office Excel 2003

Chapter 12. Logical Functions

In this chapter

• Logical Functions Overview

• AND

• IF

• NOT

• OR

Logical Functions Overview

Logical functions test cells and ranges and return a logical result in the form of text (True or False) or numbers (1 or 0). A logical function operates under a logical test. For example, if you want to apply a simple addition based on whether a cell has a number in it, you could use an IF function to test the cell and then apply the simple addition if the logical result is true. This chapter covers the functions in Table 12.1 that appear in bold.

Table 12.1. Logical Functions

Function	Syntax	Description
AND	=AND(logical1,logical2,...)	Returns TRUE if all of the arguments are true in the formula, and FALSE if one or more are false.
FALSE	=FALSE() ...