Chapter 12. Logical Functions

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() ...

Get Special Edition Using® Microsoft® Office Excel 2003 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.