O'Reilly logo

iWork® For Dummies,® 2nd Edition by Jesse Feiler

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

Chapter 16

Working with Cells and Formulas (Mac)

In This Chapter

arrow Creating formulas

arrow Using summary formulas

arrow Working with functions

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

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