Apple Pages 2 - Manual (Page 188)

188 Chapter 8 Creating Tables
m Select a table cell, click Inspector in the toolbar, and click the Table Inspector button.
In the Numbers pane, choose Formula Editor from the Insert Formula pop-up menu.
To add a new formula using the Formula Editor:
1 Select the cell in which you want to display the result of the formula.
2 Open the Formula Editor. For example, type the equal sign (=).
3 Type a formula in the text field, or click the Insert Formula button to use a predefined
function.
See “Using Cell References” on page 189 to learn techniques for including cell
references in your formulas.
See “Using Predefined Functions” on page 191 to learn how to insert a function into a
formula by using the Formula Editor’s Insert Formula button.
See “Performing Arithmetic Operations” on page 191 to learn how to add a formula
that performs arithmetic.
See “Operators and Functions for Advanced Table Formula Users” on page 193 for
detailed information about using specific operators and functions in formulas.
4 Click the Accept button to save your formula.
To edit an existing formula:
m Double-click a table cell that contains a formula. The Formula Editor opens, with the
formula displayed in the text field. You can use the arrow keys to move the insertion
point around in the text field.
To save a formula:
m In the Formula Editor, press Return, press Enter, or click the Accept button.
m Click outside the table.
To discard changes you’ve made to a formula:
m In the Formula Editor, press Esc or click the Cancel button.
m To close the Formula Editor and discard changes, click the Close button.