Apple AppleWorks 5 : Windows 95/NT 4.0 - Manual (Page 157)

Spreadsheet 7-23
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 Help menu and type the first few letters of the entry. Double-click the
entry and then double-click a 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
Enter a reference to
a cell range Drag to select the range that you want to refer to.
The reference to the cell range appears at the
insertion point in the formula. Then enclose the
range in parentheses.
Or type the addresses of the cell at the upper left of
the range and the cell at the lower right with two
dots between them and enclose the range in
parentheses.
=SUM(B1..C1)
Enter an absolute
cell reference Click in the entry bar before the part of the cell
address that you want to make absolute and then
type a dollar sign ($). =$A$1+B$1+$C1
Enter a reference to
a named cell or
range Choose the name of the cell or range from the
menu in the entry bar.
For more information, see “Naming cells and
ranges” on page 7-12.
=Revenue-Expenses
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