Excel Workbook For Dummies, 2nd Edition

Chapter 13

Using Logical Functions

IN THIS CHAPTER

Finding how the Logical functions operate

Using Logical functions to create decision-making formulas

Using Logical functions to create formulas that trap errors

The Logical function category is a small but powerful group of functions (including TRUE, FALSE, IF, AND, OR, and NOT) that you can use in decision-making formulas. (A decision-making formula is one where one set of values should be used or action taken when a particular condition is met and another when it is not.) You can also combine them with certain Information functions (such as ISBLANK, ISNUMBER, ISTEXT, and ISERROR) to create error-trapping formulas that prevent Excel error values (especially #DIV/0!, #NUM!, and #VALUE! errors) from spreading to other dependent formulas in the worksheet.

In this chapter, you get a chance to practice using the Logical functions in worksheets to create both decision-making and error-trapping formulas.

Working with the Logical Functions

The logical functions, as their name implies, deal exclusively with the logical values of TRUE and FALSE. With the exception of the TRUE and FALSE functions (the only purpose of which is to return the ...