Hp Prime Graphing Wireless Calculator Bedienungsanleitung PDF herunterladen (Seite 146)

142 Functions and commands

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 234 for details. Note that

only the first four are required. fix is the number of decimal

places to be used in the displayed results.

1 2 ... 141 142 143 144 145 146 147 148 149 150 151 ... 333 334

Keine Kommentare

Hp Prime Graphing Wireless Calculator Bedienungsanleitung Seite 146