Apple AppleWorks 5 : Mac OS - Manual (Page 169)

Spreadsheet 7-23
Circular references Avoid circular references in a spreadsheet. A circular
reference occurs when two or more cells refer to each other—for example
when cell A1 contains =B2*3 and cell B2 contains =A1+4. A circular
reference also occurs when a cell refers to itself, for example, in the formula
A10=SUM(A1..A10).
AppleWorks marks cells that contain circular references with bullets. To
turn off the markings, choose Display from the Options menu, and then
deselect Mark circular refs.
Entering formulas
You can type each of the formula elements or have AppleWorks enter cell
references and functions for you. To enter a formula, select the cell where
you want the formula’s result to go and type an equal sign (=) in the entry
bar. Type the formula after the equal sign (you can put a space before or after
any operators), and then click to confirm your entry.
Tip You can quickly total the values in selected cells and display the result
in the row or column cell adjacent to the selected cells. Select the cells
(including a blank cell to display the total) and click
on the Default button
bar.
* Choose Index from the or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
To Do this Example
Enter a reference to
a single cell Click to select the cell that you want to
refer to. AppleWorks enters a plus sign (+)
when you click the next cell. (To use a
different operator—such as * to multiply—
type the operator before you click the next
cell.) AppleWorks inserts the cell reference
at the insertion point in the formula. =B1+C1
=B1*C1
Circular reference
In the Help index, * see:
E
arithmetic operators
E
spreadsheets, calculations
Select the cells to be totaled
and the cell for the result Before After