Apple Pages '08 - Manual (Page 190)

190 Chapter 9 Using Formulas and Functions in Tables
Here’s a formula that adds the values in nine cells of the first column: SUM(A2:A10).
There is one argument, A2:A10. The colon means the function should use the values
in cells A2 through A10.
You don’t need to understand more than this to use formulas in tables. Templates (such
as the Invoice template) and formula editing tools (such as the Formula Editor) make
basic formulas easy to use.
A Tour of Using Formulas
Reviewing the formulas built into the Invoice template is a good introduction to Pages
formulas.
1 Create a new Pages document using the Invoice template.
Open Pages, choose File > New, click Forms, select Invoice, and then click Choose.
The table in this template uses formulas to derive the values in the Cost column.
2 Select the table, and then double-click the value in the Cost cell in the first row. The
Formula Editor opens, revealing that the value is derived using a formula.
The asterisk symbol (*) is the multiplication operator.
A formula in each cell in the
Cost column automatically
updates totals when quantity
or unit price changes.
The formula in the Cost cell in
the first row multiplies the values
in two other cells—B2 and C2.