08

Chapter 7 Using Formulas and Functions in Tables 137
Using the Formula Editor
The Formula Editor lets you create and modify formulas.
Here are ways to open the Formula Editor:
m Select a table cell and then type the equal sign (=).
m Select a table cell, click Inspector in the toolbar, click the Table Inspector button, and
then click Format. Choose Formula Editor from the Quick Formula pop-up menu.
m Select the table, and then double-click a table cell that contains a formula.
m Select a table cell, and then choose Insert > Function > Formula Editor.
When the Formula Editor opens, it appears over the selected cell. To move the Formula
Editor, hover the cursor over the left side of the Formula Editor until the cursor changes
into a hand, then click and drag.
When you select a cell that contains a formula, its arguments are highlighted in color.
Adding a New Formula with the Formula Editor
Use the Formula Editor to create a formula.
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 Use the text field to specify the formula, making sure the equal sign is the first
character in your formula.
To learn techniques for including cell references in your formulas, see “Using Cell
References” on page 138.
To learn about using operators in formulas, see “Using Operators” on page 140.
To learn how to insert a function into a formula, see “Using Functions” on page 143.
4 To save changes, press Return, press Enter, or click the Accept button in the Formula
Editor. You can also click outside the table.
To close the Formula Editor and discard changes, press Esc or click the Cancel button in
the Formula Editor.
Move the Formula Editor
by grabbing here
and dragging.
Text field
View or edit a formula.
Cancel button
Discard changes.
Accept button
Save changes.