Apple numbers User Manual
90
Chapter 5
Using Formulas and Functions in Tables
3
To save changes, press Return, press Enter, or click the Accept button in the Formula
Editor. You can also click outside the table.
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.
the Formula Editor.
Using the Formula Bar
The Formula Bar, located beneath the Format Bar, lets you create and modify formulas
in a selected cell.
in a selected cell.
If you click a selected formula cell, the Formula Editor opens and you can use it to edit
your formula instead of using the Formula Bar. See “Editing a Formula with the Formula
Editor” on page 89 for details.
your formula instead of using the Formula Bar. See “Editing a Formula with the Formula
Editor” on page 89 for details.
Adding a New Formula with the Formula Bar
Use the Formula Bar to create a formula.
To add a new formula using the Formula Bar:
1
Select the cell in which you want to display the result of the formula.
2
Click in the text field of the Formula Bar to enter the formula. Make sure that the equal
sign (=) is the first character in your formula.
sign (=) is the first character in your formula.
To learn techniques for including cell references in your formulas, see “Using Cell
References” on page 91.
References” on page 91.
To learn about using operators in formulas, see “Using Operators” on page 94.
To learn how to insert a function into a formula, see “Using Functions” on page 96.
3
To save changes, press Return, press Enter, or click the Accept button in the Formula
Bar.
Bar.
To discard changes, press Esc or click the Cancel button in the Formula Bar.
Text field
View or edit a formula.
View or edit a formula.
Cancel button
Discard changes.
Discard changes.
Accept button
Save changes.
Save changes.
Click to open the
Function Browser.