iWork® For Dummies,® 2nd Edition

Chapter 16

Working with Cells and Formulas (Mac)

In This Chapter

Creating formulas

Using summary formulas

Working with functions

Using a lookup function

One of the most important features of any spreadsheet is the ability to place formulas into cells. Other spreadsheets, such as Microsoft Excel, offer functions and formulas — often the same ones you find in Numbers. Spreadsheet users expect to find a SUM function along with a TODAY function and all the other functions that they’re accustomed to, particularly if they switch back and forth between spreadsheet applications or if they’re sharing their documents. What sets Numbers apart is the ease with which you can create and manage formulas along with the large number of templates that implement sophisticated uses of formulas and functions.

Starting to Use Formulas

Formulas can contain specific values (called constants and sometimes literals); they also can contain references to cells in the spreadsheet. If a formula contains a reference to a cell, every time that cell’s value is updated, the formula is reevaluated. A formula can contain ...