iWork: The Missing Manual

Chapter 19. Using Formulas

Just on its own, a table is good. It gets your data organized and sorted, all in one place. And now that you know how to build and style this baby, you can show it off with panache. But your table doesn’t do much yet. Isn’t a spreadsheet supposed to balance your checkbook, manage your company’s budget, and find you true love? Although Numbers might not offer any love potions, it does have all kinds of other formulas to set your grid in motion.

In Numbers, formulas are responsible for the fundamental magic behind your spreadsheet, mixing and mashing your raw data into facts, figures, and bottom-line tallies. Formulas are equations that you add to cells to make them calculate: add up columns, find average grades, or figure the net present value of an investment. A formula’s calculations can range anywhere from simple math (1+1) to complex constructions that gather values from other tables or apply sophisticated financial algorithms. This chapter starts you at the shallow end of that pool, getting you acquainted with Numbers’ basic arithmetic before you move on to the gee-whiz functions magic in the next chapter.

Whether your table’s math is simple or sophisticated, Numbers makes the process of adding and editing formulas easy, giving you lots of ways to build and insert these number-crunching gizmos into your table’s cells. You can compose an elaborate formula by hand, sure, but you can also drag and drop common calculations into a table or add up a column ...