Apple numbers User Manual

    Dictionary of Functions 

 

The MINUTE function extracts the minutes from a date or time.

MINUTE(date-time)

 date-time:  Any valid Numbers date or time value.

  

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.

  

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).

MINUTE("4/6/88 11:59:22 AM") returns 59.

MIRR({-5000, 2000, 4000, -2000, 5000}, 0.1, 0.15) returns 19.66% (when using the percent number 
format).