Apple numbers User Manual

    Dictionary of Functions 

 

3 uses actual/365 (calendar days for each month but 365 days per year).

4 uses 30E/360 (European 30/360).

  

The ACCRINTM function calculates the total accrued interest for a security that pays 
interest at maturity.

ACCRINTM(issue, settle, rate, par, [day-count])

 issue:  The date when the security was issued.
 settle:  The date of the settlement, usually the date when the security was purchased.
 rate:  The coupon rate of the security, expressed as a percentage from 0 to 1.
 par:  The face value of the security.
 day-count:  Optional; specifies the number of days per month and days per year used 

in the calculations (sometimes called the day count basis).

0 or omitted uses 30/360 (30 days for each month, 360 days in a year).

1 uses actual/actual (the number of days shown on a calendar).

2 uses actual/360 (calendar days for each month but 360 days per year).

3 uses actual/365 (calendar days for each month but 365 days per year).

4 uses 30E/360 (European 30/360).

  

The ACOS function calculates the inverse cosine (arccosine) of a number. While the COS 
function takes an angle and returns its cosine, the ACOS function does the opposite; it 
takes a cosine value and returns a corresponding angle. The resulting angle is 
expressed in radians, in the range 0 to pi.

ACOS(cos)

 cos:  A cosine value in the range –1 through 1.

If A1:A7 contain 1/1/2000, 3/1/2000, 7/1/2000, 0.10, 1000, 2, 0:
 

ACCRINT(A1, A2, A3, A4, A5, A6, A7) returns 50.

If A1:A5 contain 1/1/2000, 10/1/2000, 0.10, 1000, 0:
 

ACCRINTM(A1, A2, A3, A4, A5) returns 75.