Using spreadsheet cell references in formulas

A spreadsheet can automatically recalculate formulas when data changes. To do this, you use references (addresses) of other cells in a formula. When you alter the data in a referenced cell, AppleWorks automatically recalculates the formula using the new data.

You can also use references to cells and spreadsheet frames in other AppleWorks documents.

To include cell references in a formula:
1 Click in the entry bar where you want to include a cell reference.
2 Add a cell reference using one of these methods:
For a single cell, click the cell or type its address.
For a range of cells, drag through the range of cells, or type the address of the upper-left cell, two periods, and the address of the lower-right cell (for example, A3..C8).
Type the name of a named cell range or choose it from the name pop-up menu (to the left of the entry bar).
If you're using multiple cell references in a single formula:
Enter an operator before each selection. (If you don't enter an operator, AppleWorks inserts a plus sign.)
Separate the references with commas. For example, the formula =AVERAGE(A12,C3,D2..D8) returns the average of the values in cells A12, C3, and the range of D2 through D8.

Including references to cells in other spreadsheet documents or frames

Note: A document or frame name must be enclosed in quotation marks if it contains spaces, special characters, or resembles a cell address or function name.

To enter a reference to a cell in another spreadsheet:
Type the document name, an exclamation point (!), and the cell address.
For example:
=Budget.CWK!A2
=SUM("Planning Budget"!A2..A31)

To reference a spreadsheet frame in the current document or another document, you must first name the frame:
1 Select the frame.
2 Choose Frame Info from the Edit menu.
3 Type a name.
To enter a reference to a cell in a spreadsheet frame in the current document:
Type the frame name in brackets, an exclamation point, and the cell address. For example:
=[West_Region]!A2
To enter a reference to a cell in a spreadsheet frame in another document:
Type the name of the document, the name of the frame (in brackets), an exclamation point, and the cell address. For example:
="Budget 1"[West_Region]!A2

Related topics

  Using formulas and functions in a spreadsheet
Entering spreadsheet data
About functions
About integrating different kinds of content

 
Table of contents Index