Table of Contents
Advertisement
Print Functions
The print functions return the name of the file, the current page, and the
number of pages with headers and footers when printing documents.
Function
Description
FII.ENAME ( )
Returns the mename
of the current file for inclusion in a Spreadsheet header or
'
footer. You must include the empty parentheses.
PAGE ( )
Returns the current page number for use in a header or footer. Must include the
empty parentheses. If you use PAGEoutside of a Spreadsheet header or footer, PAGE
is calculated when you print.
PAGES ( )
Returns the total number of pages in a document for use in a header or footer.
You must include the empty parentheses. If you use PAGESoutside of a header or
footer, PAGES is calculated when you print.
Statistical Functions
The arguments
for statistical
functions
consist
of either
numbers
or addresses
of cells that contain
numbers.
The results of these
calculations
are always
numbers.
Function
AVG (valuel,
value2,...)
Description
Average
of the values in a list. You can use as many arguments
as you want. AVG
treats empty cells as zero values. You cannot average cells containing
text.
MAX (valuel,
Largest number
in a list. Listcan include values or addresses, separated by commas.
value2,...)
MAXignores empty cells and treats text as a zero.
MIN (valuel,
Smallest amber
value in a list. Listcan include values or addresses, separated by
value2,...)
commas. MIN ignores empty cells and treats text as a zero.
RANDOM
( )
Random number between 0 and 1. RANDOMreturns a new random number with
every recalculation. RANDOM0 returns a decimal value.
II
_MN
(value)
Ramdom number betweea Oand t,akm_l, a number you specify. RANDOMN
:returns a new random number with every recalculation. For example,
RANDOMN(100)returns a number between 0 and 99.
--.STD (valuel,
value2,_)
Standard deviation of the values in a list. You can use as many va/ues as you want.
Appendix
223
Advertisement
Table of Contents
