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 ...
Get iWork: The Missing Manual now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.