O'Reilly logo

Special Edition Using® Microsoft® Office Excel 2003 by Patrick Blattner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required