Apple Numbers '08 - Manual (Page 250)

250 Chapter 12 Dictionary of Functions
MINUTE
The MINUTE function extracts the minutes from a date or time.
MINUTE(date-time)
 date-time: Any valid Numbers date or time value.
MIRR
The MIRR function calculates the modified internal rate of return of a series of periodic
cash flows. MIRR stands for modified internal rate of return.
MIRR(cash-flows, finance-rate, reinvest-rate)
 cash-flows: One or more future cash flows. Values are ranges or arrays.
 finance-rate: The interest rate on cash-flows.
 reinvest-rate: The rate at which positive cash flows can be reinvested.
MOD
The MOD function calculates the remainder upon division.
MOD(number, divisor)
 number: The dividend. It’s a number, cell reference, or the result of an arithmetic
operation.
 divisor: Any number but 0. The sign of the result matches that of the dividend, no
matter what the sign of the divisor is.
Notes
When both a positive and a negative remainder exist, MOD returns the remainder
whose sign matches the sign of the divisor.
When computing MOD(a, b), MOD gives a number r such that a = bk + r, where r is
between 0 and b, and k is an integer.
MOD(a,b) is equivalent to a–b*INT(a/b).
Examples
MINUTE("4/6/88 11:59:22 AM") returns 59.
Examples
MIRR({-5000, 2000, 4000, -2000, 5000}, 0.1, 0.15) returns 19.66% (when using the percent number
format).