Formulas and Functions

Chapter 1 Using Formulas in Tables 19
To use m all the values in a row, rst click the row’s header cell or reference tab. Then,
in Numbers, click Function in the toolbar, and choose a calculation from the pop-
up menu. In Keynote or Pages, choose Insert > Function and use the submenu that
appears.
The result is placed in a new column. Clicking on the cell will display the formula.
Creating Your Own Formulas
Although you can use several shortcut techniques to add formulas that perform
simple calculations (see “Performing Instant Calculations in Numbers” on page 17 and
“Using Predened Quick Formulas” on page 18), when you want more control you use
the formula tools to add formulas.
To learn how to Go to
Use the Formula Editor to work with a formula “Adding and Editing Formulas Using the Formula
Editor” (page 19 )
Use the resizable formula bar to work with a
formula in Numbers
“Adding and Editing Formulas Using the Formula
Bar” (page 20)
Use the Function Browser to quickly add
functions to formulas when using the Formula
Editor or the formula bar
“Adding Functions to Formulas” (page 21)
Detect an erroneous formula “Handling Errors and Warnings in
Formulas” (page 23)
Adding and Editing Formulas Using the Formula Editor
The Formula Editor may be used as an alternative to editing a formula directly in the
formula bar (see “Adding and Editing Formulas Using the Formula Bar” on page 20).
The Formula Editor has a text eld that holds your formula. As you add cell references,
operators, functions, or constants to a formula, they look like this in the Formula Editor.
All formulas must begin
with the equal sign.
The Sum function.
References to cells
using their names.
A reference to a
range of three cells.
The Subtraction
operator.
Here are ways to work with the Formula Editor:
To open the Formula Editor, do one of the following: m
Select a table cell and then type the equal sign (=). Â
In Numbers, double-click a table cell that contains a formula. In Keynote and Pages, Â
select the table, and then double-click a table cell that contains a formula.
In Numbers only, select a table cell, click Function in the toolbar, and then choose Â
Formula Editor from the pop-up menu.