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

7-26 AppleWorks 5 User’s Manual
To change the formula, for example to use a different operator, use the
text editing techniques described in “Editing data” on page 7-6.
3. Click to confirm the entry.
AppleWorks adds the numbers and displays the result (950) in
cell B3. If the result doesn’t appear as you expect, check to be sure that
you started the formula with an equal sign (=).
Working with functions
AppleWorks provides functions, or built-in routines, that you can use alone
or include in a formula. Use functions to perform computations—such as
summing a group of numbers or deriving a square root—without having to
type the entire formula. You can use a function by itself in a formula, or you
can combine it with other values, operators, cell references, and functions.
For an example of a simple function, see “Example: Using the AVERAGE
function” on page 7-27.
AppleWorks provides over 100 functions in nine general categories. A
complete list of these functions is in onscreen Help.
* 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.
Category Purpose Example
Business and
Financial Calculates mortgage and payment values PMT (Payment)
Date and Time Manipulates dates and times DATE
Information Looks up and evaluates information in
spreadsheet cells, cell ranges, and database fields
LOOKUP
Logical Evaluates Boolean expressions, which result in
either TRUE or FALSE ISBLANK
Numeric Performs general mathematical calculations ROUND
Statistical Calculates general statistics, such as standard
deviation and variance AVERAGE
Text Finds, compares, and manipulates text
expressions CODE (ASCII code)
Trigonometric Creates and evaluates mathematical and
scientific values SIN
In the Help index, * see:
E
functions