Apple numbers User Manual
88
Chapter 5
Using Formulas and Functions in Tables
Here are ways to perform basic calculations using values in a column:
m
To use values in a range of adjacent cells, select the cells, click Function in the toolbar,
and choose a calculation from the pop-up menu.
and choose a calculation from the pop-up menu.
Numbers places the formula and its result in the first empty cell beneath the selected
cells. If there is no empty cell, Numbers adds a row to hold the result.
cells. If there is no empty cell, Numbers adds a row to hold the result.
m
To use all the values in a column, click the column’s header cell or reference tab, click
Function in the toolbar, and choose a calculation from the pop-up menu.
Function in the toolbar, and choose a calculation from the pop-up menu.
Numbers places the formula and its result in a footer row. If a footer row doesn’t exist,
Numbers adds one.
Numbers adds one.
Performing a Basic Calculation Using Row Values
Using the pop-up menu of the Function button in the toolbar makes it easy to perform
basic calculations on adjacent values in a row and display the results.
basic calculations on adjacent values in a row and display the results.
Here are ways to perform basic calculations using values in a row:
m
To use values in a range of adjacent cells, select the cells, click Function in the toolbar,
and choose a calculation from the pop-up menu.
and choose a calculation from the pop-up menu.
Numbers places the formula and its result in the first empty cell to the right of the
selected cells. If there is no empty cell, Numbers adds a column to hold the result.
selected cells. If there is no empty cell, Numbers adds a column to hold the result.
m
To use all the values in a row, click the row’s header cell or reference tab, click Function
in the toolbar, and choose a calculation from the pop-up menu.
in the toolbar, and choose a calculation from the pop-up menu.
Numbers places the formula and its result in a new column.
Removing a Formula
If you no longer want to use a formula that's associated with a cell, you can quickly
remove the formula.
remove the formula.
To remove a formula from a cell:
1
Select the cell.
2
Press the Delete key.
Using the Formula Editor
The Formula Editor lets you create and modify formulas.
Move the Formula Editor
by grabbing here
and dragging.
Text field
View or edit a formula.
View or edit a formula.
Cancel button
Discard changes.
Discard changes.
Accept button
Save changes.
Save changes.