Apple Numbers '08 - Manual (Page 205)

Chapter 12 Dictionary of Functions 205
Function Descriptions
The function descriptions in this section are arranged in alphabetical order by function
name.
ABS
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.
ACCRINT
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).
Examples
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.