Filter
Top Products
Functions and commands 347
AMORT Calculates the principal, interest, and balance of a loan over
a specified period.
AMORT(Range, n, i, pv, pmt[, ppyr=12,
cpyr=ppyr, Grouping=ppyr, beg=false,
fix=current], "configuration"])
Range is the cell range where the results are to be placed. If
only one cell is specified, then the range is automatically
calculated.
Configuration is a string that defines if a header row needs to
be created (starts with H) and what result to place in which
column.
h – show row 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
n, i, pv, and pmt are the number of periods for the loan, the
interest rate, the present value, the per-period payment. ppyr
and cpyr are the number of payments per year and the
number of compounding periods per year. Grouping is the
number of periods that need to be grouped together in the
amortization table. beg is 1 when payments are made at the
beginning of each period; otherwise it is 0. fix is the number
of decimal places to used in the results the calculations.
STAT1 The STAT1 function provides a range of one-variable statistics.
It can calculate all or any of , Σ, Σ², s, s², σ, σ², serr, sqd,
n, min, q1, med, q3, and max.
STAT1(Input range, [mode], [outlier
removal Factor], ["configuration"])
Input range is the data source (such as A1:D8).
Mode defines how to treat the input. The valid values are:
1 = Single data. Each column is treated as an
independent dataset.
x