Formulas and Functions

In Numbers only, select a table cell and then choose Insert > Function > Formula Â
Editor. In Keynote and Pages, choose Formula Editor from the Function pop-up
menu in the Format pane of the Table inspector.
Select a cell that contains a formula, and then press Option-Return. Â
The Formula Editor opens over the selected cell, but you can move it.
To move the Formula Editor, hold the pointer over the left side of the Formula Editor m
until it changes into a hand, and then drag.
To build your formula, do the following: m
To add an operator or a constant to the text eld, place the insertion point and type. Â
You can use the arrow keys to move the insertion point around in the text eld. See
“Using Operators in Formulas” on page 28 to learn about operators you can use.
Note: When your formula requires an operator and you haven’t added one, the
+ operator is inserted automatically. Select the + operator and type a dierent
operator if needed.
To add cell references to the text eld, place the insertion point and follow the Â
instructions in “Referring to Cells in Formulas” on page 24.
To add functions to the text eld, place the insertion point and follow the Â
instructions in “Adding Functions to Formulas” on page 21.
To remove an element from the text eld, select the element and press Delete. m
To accept changes, press Return, press Enter, or click the Accept button in the Formula m
Editor. You can also click outside the table.
To close the Formula Editor and not accept any changes you made, press Esc or click
the Cancel button in the Formula Editor.
Adding and Editing Formulas Using the Formula Bar
In Numbers, the formula bar, located beneath the format bar, lets you create and
modify formulas for a selected cell. As you add cell references, operators, functions,
or constants to a formula, they appear like this.
The Subtraction operator.
References to cells
using their names.
The Sum function.
All formulas must begin
with the equal sign.
A reference to a
range of three cells.
Here are ways to work with the formula bar:
To add or edit a formula, select the cell and add or change formula elements in the m
formula bar.
To add elements to your formula, do the following: m
20 Chapter 1 Using Formulas in Tables