Apple Numbers '08 - Manual (Page 258)

258 Chapter 12 Dictionary of Functions
POWER
The POWER function raises a number, the base, to a power, the exponent. Produces the
same result as the ^ operator.
POWER(base, exponent)
 base: The number that you want to raise to a power.
 exponent: The power to which you want to raise the base number.
Notes
You can also use the exponentiation operator ^ to raise a number to a power:
POWER(2, 3) has the same result as 2^3.
PPMT
The PPMT function calculates the principal portion of a payment for a loan or
investment at a specified period based on periodic fixed payments and a fixed interest
rate.
PPMT(rate, period, num-periods, present-value, [future-value], [when-due])
 rate: The interest rate for each period.
 period: The period for which you want to find the principal.
 num-periods: The number of periods in the life of the investment.
 present-value: The present value of the loan or investment.
 future-value: Optional; the target future value, if this in an investment. If omitted,
assumed to be 0.
 when-due: Optional; specifies whether payments are made at the beginning or end
of each period:
0 (or omitted) means payments are at the end of each period.
1 means payments are at the beginning of each period.
Examples
For a mean of 10 and an arrival rate of 8:
POISSON(8, 10, FALSE) returns 0.112599.
Examples
POWER(2, 3) returns 8.
POWER(2, 10) returns 1024.
POWER(0.5, 3) returns 0.125.
POWER(100, 0.5) returns 10.