Using the formula editor – Apple iWork '08 User Manual

Page 82

Advertising
background image

82

Chapter 2

Getting Started with Numbers

3

To commit the value, click cell B2, type 4000, and then press Tab.

Notice that the sum changes to $6,500.

To view a formula:

m

Click the cell in which the sum is displayed (cell B7), and look at the Formula Bar

(beneath the Format Bar) to view the formula associated with the cell.

The formula in the cell is SUM(‘Jan-Mar’). SUM is a function that adds together the

values in the arguments specified between the parentheses. In this case, the column

heading is the argument; using a header cell name is an easy way to refer to all the

values in a column or row.

Using the Formula Editor

Another way to add, view, and edit formulas is to use the Formula Editor.

To view a formula using the Formula Editor:

m

Double-click cell B7.

View or edit the formula
in the text field.

Click the Cancel button
to discard changes.

Click the Accept button
to save changes.

Click to open the
Function Browser.

Advertising