2007 Microsoft® Office System Step by Step, Second Edition

Summarizing Data That Meets Specific Conditions

Another use for formulas is to display messages when certain conditions are met. For instance, Consolidated Messenger’s VP of Marketing, Craig Dewar, might have agreed to examine the rates charged to corporate customers who were billed for more than $100,000 during a calendar year. This kind of formula is called a conditional formula, and it uses the IF function. To create a conditional formula, you click the cell to hold the formula and open the Insert Function dialog box. From within the dialog box, click IF in the list of available functions, and then click OK. The Function Arguments dialog box opens.

When you work with an IF function, the Function Arguments dialog box has three boxes: Logical_test, ...