Apple Numbers '08 Manual do Utilizador descarregar pdf (Página 263)

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

1 2 ... 258 259 260 261 262 263 264 265 266 267 268 ... 294 295

Sem comentários

Apple Numbers '08 Manual do Utilizador Página 263