Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual
Page 149
Spreadsheet
7-15
Example 1: Using cell names in a formula
This example shows you how to name two cells and use the names in
a formula.
1.
Open a new, blank spreadsheet document, and then type
Income
,
Expenses
,
and
Profit
in cells A1, A2, and A3, respectively.
2.
Format column B for currency.
Select the entire column, click
on the Default button bar (or choose
Number from the Format menu, select Currency, and then click OK).
3.
Select cell B1 and choose Define Name from the
menu in the entry bar.
4.
Click Define to accept the suggested name,
Income
.
5.
Select cell B2 and choose Define Name from the
menu in the entry bar.
6.
Click Define to accept the suggested name,
Expenses
.
7.
Cells B1 and B2 are now named Income and Expenses.
8.
Type
1000
and
800
in cells B1 and B2, respectively.
9.
Select cell B3 and type an equal sign (=).
10.
Choose Income from the
menu in the entry bar and type a minus sign (
-
).
11.
Choose Expenses from the
menu in the entry bar and then press Enter.
Cell name appears here