Apple numbers User Manual

 Dictionary of Functions

 

Function Descriptions

The function descriptions in this section are arranged in alphabetical order by function 
name.

The ABS function calculates the absolute value of a number. The result is either a 
positive number or zero.

ABS(number)

 number:  A number, a numeric expression, or a reference to a cell containing a 

numeric expression.

  

The ACCRINT function calculates the total accrued interest for a security that pays 
periodic interest.

ACCRINT(issue, first, settle, rate, par, frequency, [day-count])

 issue:  The date when the security was issued.
 first:  The date of the first interest payment.
 settle:  The settlement date, 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.
 frequency:  The number of coupon payments each year.

1 means annual payments.

2 means semiannual payments (twice per year).

4 means quarterly payments (four times per year).

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

If cell A1 contains 5, ABS(A1) returns 5.
 

ABS(8-5) returns 3.

ABS(5-8) returns 3.

ABS(0) returns 0.

If cell A1 is empty, ABS(A1) returns 0.