Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual
Page 155
Spreadsheet
7-21
Important
The examples in this documentation are based on U.S.
conventions. For example, dates and numbers are shown in U.S. formats. In
English-speaking countries other than the United States, functions, formulas,
and calculations might be formatted differently. For example, in the U.S.,
commas act as separators in formulas. In other countries, semicolons might
be used as separators.
Understanding formulas
Within a single formula, you can calculate a result using:
1
values, such as $4.95, Ms. Jane Smith, or February 2, 1997
1
operators, such as +, -, *, =, >, or ()
1
cell references, such as B2, P66, or D7
1
functions, such as =SUM(B2+N66) or =PRODUCT(A1..C1)
1
named ranges
Formulas can be simple or very complex, with many parts. All of these are
legitimate (and simple) formulas:
See “Working with functions” on page 7-26 for more information on
functions.
*
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.
This formula
Does this
=B6+B8
Adds the values in cells B6 and B8
=E9*3.5
Multiplies the value in cell E9 by 3.5, a constant (fixed value)
that you supply
=Shares*Price
Multiplies the values in two named cells (see “Naming cells
and ranges” on page 7-12)
=“California”
Places a text constant (California) in a cell
=SUM(D4..D12)
Uses the SUM function (a predefined formula) to add the
values in the cell range D4 to D12
In the Help index,
*
see:
E
spreadsheets, calculations