Table of Contents
Advertisement
Spreadsheet's
built-in
function types are
listed on page 91.
More information
about each function
and argument is in bSe
Appendix, beginning
on page 215.
You can embed one
function within
another. For
example, to sum a
range of values and
get its integer value,
you could type
=INT(SUM(A3:Ag)).
3. Select
the function
from the Functions
list on the fight. You can select
a
function
type from the list on the left so that the Functions
list shows
only
functions
of the type you select.
4, Select
Paste Arguments
(the default)
ff you want
to insert placeholder
arguments
with the function.
Click on Paste. The function
appears
in the Edit Area
with p[acebolders.
Click on Close.
.
6.
7.
8.
In the Edit Area, double-click
on the first argument to select it.
Type the text, value, formula or cell reference
you want to use for the
argument. Make sure you type it correctly. Your entry replaces the
p/acebo/der
argument.
9. Continue replacing
arguments as needed.
10. Press ENTER.
11. When the calculation
is complete,
the result appears in the spreadsheet.
If
the calculated
re.sult is not what you expect, be sure that you typed the
formula correctly.
12. Click on Close.
I_ To insert a function
by typing:
1. Select
the cell where
you want
the result
of the calculation
to appear.
2. Type
= to begin
the formula.
The equal
sign appears
in the Edit Area.
3. Type
the function
name
(for example,
--SUM).
4. Type
the arguments,
enclosed
in parentheses.
Be sure to include
commas
-
betwed-ff
argumenrs-(for_Lamp|e,
=SUM(A1,A2)).
"
5.
Press
ENTER. When
the calculation
is complete,
the result appears
in the
spreadsheet.
To use a function
within a function:
1. Insert
the first function.
2. In the Edit Area,
select
the argument
you want
to replace
with a function.
3. Insert the second
function.
4. Continue
in this manner
until the formula
is complete.
5. Press
ENTER.
Spreadsheet
90
Advertisement
Table of Contents
