Microsoft Office Tutorials and References
In Depth Information
11. Type [ , and then in the Formula AutoComplete list, click Labor Expense , and
Excel extends the formula to read =SUM(JuneSummary[Labor Expense .
12. Type ]) to complete the formula, and then press Enter.
The value $637,051.00 appears in cell F13.
CLEAN UP Save the ITExpenses workbook, and then close it.
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 ;
one way to create a conditional formula in Excel is to use 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. When you do, the Function Arguments dialog box opens.