Apple Keynote 3 - Manual (Page 112)

112 Chapter 5 Creating Tables
2 Click Inspector in the toolbar, click the Table Inspector button, and click Numbers.
3 Choose a formula from the Quick Formula pop-up menu.
Keynote places the formula and its result in the first empty cell to the right of the
selected cells. If there is no empty cell, Keynote creates a new column to hold the
result.
If the row has a header cell and you want the formula to use all the values in the row,
click the header cell before choosing the quick formula.
To remove a formula from a cell:
1 Select the cell.
2 Press the Delete key.
Using the Formula Editor to Add and Edit Formulas
The Formula Editor lets you control the content of your formulas.
The Formula Editor
You use the Formula Editor to enter or modify formulas.
To open the Formula Editor, do one of the following:
 Select a table cell and type an equal sign (=).
A green selection border appears around the cell to indicate that you’re in formula
mode.
Insert Function button
Click and hold to choose a
predefined function from
the pop-up menu.
An equal sign is always
the first element in a
formula.
Text field
View or edit a
formula in this field.
Cancel button
Discard changes.
Accept button
Save changes.