Filter
Top Products
Functions and commands 351
AVERAGE Calculates the arithmetic mean of a range of numbers.
AVERAGE([input])
For example, AVERAGE(B7:B23) returns the arithmetic
mean of the numbers in the range B7 to B23. You can also
specify a block of cells, as in AVERAG(B7:C23).
An error is returned if a cell in the specified range contains a
non-numeric object.
AMORT Amortization. Calculates the principal, interest, and balance
of a loan over a specified period. Corresponds to pressing
in the Finance app.
AMORT(Range, NbPmt, IPYR, PV, PMTV[, PPYR=12,
CPYR=PPYR, GSize=PPYR, BEG=0, fix=current],
"configuration"])
Range: the cell range where the results are to be placed. If
only one cell is specified, then the range is automatically
calculated starting from that cell.
Configuration: a string that controls what results are
shown and the order in which they appear. An empty string
"" displays the default: all results, including headers. The
options in the configuration string are separated by spaces.
h – show row headers
H – show column headers
S – show the start of the period
E – show the end of the period
P – show the principal paid this period
B – show the balance at the end of the period
I – show the interest paid this period
All the other input parameters (except fix) are Finance app
Numeric view variables; see page 440 for details. Note that
only the first four are required. fix is the number of decimal
places to be used in the displayed results.