Apple Pages Guia do Utilizador descarregar pdf (Página 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.

1 2 ... 185 186 187 188 189 190 191 192 193 194 195 ... 245 246

Sem comentários

Apple Pages Guia do Utilizador Página 190