Apple Keynote '08 - Manual (Page 140)

140 Chapter 7 Using Formulas and Functions in Tables
To apply a header formula to cells in a column or row:
1 Select the header cell for the column or row.
2 Open the Formula Editor. For example, type the equal sign (=).
3 Type the formula you want to apply to each cell in the column or row.
For example, to assign values to the cells of column C that are five times greater than
the corresponding cell in column B, you’d use the formula B*5 or B:B*5.
The formula is duplicated in all the cells in the column or row. In this example, cell C4
would contain the value computed by using the formula B4*5.
4 Click the Accept button or press Return or Enter to save the formula.
Handling Errors and Warnings
When a formula in a table cell is incomplete, contains invalid cell references, or is
otherwise incorrect, or when an import operation creates an error condition in a cell,
Keynote displays an icon in the cell. A blue square in the upper left of a cell indicates
one or more warnings. A red triangle in the middle of a cell means that a formula error
occurred.
To view error and warning messages:
m Click the icon.
A message window summarizes each error and warning condition associated with the
cell.
Using Operators
Use operators in formulas to perform arithmetic operations and compare values:
 Arithmetic operators perform arithmetic operations, such as addition and subtraction,
and return numerical results.
 Comparison operators compare two values and return TRUE or FALSE.
Performing Arithmetic Operations
To create a formula that performs an arithmetic operation, you use arithmetic
operators. For example, to add three values in a column, you could create a formula
that looks like this: A2 + A3 + A5.