Quotient, Radians – Apple Numbers '08 User Manual

Page 263

Advertising
background image

Chapter 12

Dictionary of Functions

263

 future-value: Optional; the future value of the investment or cash value remaining

after final payment. If omitted, future value is assumed to be 0 and you must include
payment.

 when-due: Optional; specifies whether payments are made at the beginning or end

of each period:

0 (or omitted) means payments are at the end of each period.

1 means payments are at the beginning of each period.

QUOTIENT

The QUOTIENT function finds the integer quotient of two numbers, that is, the whole
part of the quotient with the fractional part (or remainder) truncated.

QUOTIENT(dividend, divisor)

 dividend: The number you want to divide.
 divisor: The number you want to divide by.

RADIANS

The RADIANS function converts degrees to radians, the standard angle measure used
for trigonometric functions.

RADIANS(degrees)

 degrees: A numeric expression.

Examples

PV(10%,5,-100,5000) returns -$2725.53, unless the cell holding the return value has been formatted.
The return value indicates that to accumulate $5,000 in five years, when making payments of $100 at
the end of each year, you would have to invest $2,725.53 now, at an interest rate of 10%.

Examples

QUOTIENT(5, 2) returns 2.

QUOTIENT(-5, 2) returns -2.

QUOTIENT(5.99, 2) returns 2.

QUOTIENT(6, 2) returns 3.

QUOTIENT(5, 6) returns 0.

Examples

RADIANS(90) returns 1.5708 (90 degrees is approximately 1.5708 radians).

RADIANS(57.2957795130823) returns 1 (1 radian is approximately 57.296 degrees).

Advertising