Apple numbers User Manual

    Dictionary of Functions 

 

  

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.
  

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. 

For a mean of 10 and an arrival rate of 8:
  

POISSON(8, 10, FALSE) returns 0.112599.

POWER(2, 3) returns 8.

POWER(2, 10) returns 1024.

POWER(0.5, 3) returns 0.125.

POWER(100, 0.5) returns 10.