Apple numbers User Manual

    Dictionary of Functions 

 

  

The ISPMT function calculates the interest due for a particular payment period of an 
investment. 

ISPMT(rate, period, num-periods, present-value)

 rate:  The interest rate for each period.
 period:  The period for which you want to find the interest.
 num-periods:  The number of periods in the life of the investment.
 present-value:  The present value of the loan or investment.

Notes
This function, which duplicates the capabilities of the IPMT function, helps you to use 
spreadsheets from older spreadsheet applications.

Be sure that the interest rate is expressed as the rate per period. For example, if the 
interest rate is 10% per year and the payment period is monthly, the rate used in the 
function should be 0.1/12 (approximately 0.00833 per month).

  

The LARGE function retrieves the nth-largest value within a range. The largest value is 
ranked number 1.

LARGE(range, n)

 range:  The array of cells containing the values.
 n:  A number representing the size ranking of the value you want to retrieve (1 is 

largest, 2 is second-largest, and so on).

Notes
If n is omitted, is less than or equal to 0, or is greater than the number of values in the 
range, an error is returned.

ISODD(3) returns TRUE.

ISODD(3.75) returns TRUE.

ISODD(2) returns FALSE.

To find the interest portion of the first payment on a $1000 loan at 12% annual interest with payments 
due at the end of each month: 
  

IPMT(0.12/12, 1, 12, 1000) returns -$10.