Apple Numbers '09 - Manual (Page 124)

To remove an element from the formula, select the element and press Delete. m
To save changes, press Return, press Enter, or click the Accept button above the m
formula bar. You can also click outside the formula bar.
To avoid saving any changes you made, click the Cancel button above the formula bar.
Adding Functions to Formulas
A function is a predefined, named operation (such as SUM and AVERAGE) that you can
use to perform a calculation. A function can be one of several elements in a formula, or
it can be the only element in a formula.
There are several categories of functions, ranging from financial functions that
calculate interest rates, investment values, and other information to statistical functions
that calculate averages, probabilities, standard deviations, and so on. To learn about all
the iWork function categories and their functions, and to review numerous examples
that illustrate how to use them, choose Help > “iWork Formulas and Functions Help” or
Help > “iWork Formulas and Functions User Guide.”
Although you can type a function into the text field of the Formula Editor or
into the formula bar, the Function Browser offers a convenient way to add a function
to a formula.
Select a function to
view information
about it.
Search for a function.
Insert the selected function.
Select a category
to view functions in
that category.
124 Chapter 6 Using Formulas in Tables