O'Reilly logo

Microsoft® Office Home and Student 2007 Step by Step by Joan Lambert, Curtis Frye, Joyce Cox

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

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, ...

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