Sharp Zaurus SL-5500 - Page 64

64 CHAPTER 3:
HancomMobileSheet
PMTPV(nper, per, rate, pv, fv, point)
Calculates the payment for a given period for a
loan
with a constant payment.
PMTPVCUM(nper, start, end, rate, pv, fv)
Calculates the cumulative payment for a series
of
period for a loan with a constant payment.
POISSON(success, average, cumulative)
Calculates the probability from a poisson distribution.
POWER(value, power)
Calculate the result of a value raised to a power.
PRODUCT(value1, value2,...)
Calculates the multiplication of all the values.
PROPER(string)
Changes the first character of each word
to
uppercase and following characters to lowercase.
PV(pmt, nper, rate, fv, point)
Calculates the present value of an investment.
QUADMEAN(value1, value2, ...)
Calculates the quadratic mean.
QUARTILE(data range, quartile number)
Returns the quartile of a data set.
QUOTIENT(numerator, denominator)
Returns the integer portion of a division.
RADIAN(degrees)
Changes the degrees to radians.
RAND( )
Returns an evenly distributed random number
greater
than or equal to 0 and less than 1.
RANK(value, data range, direction)
Calculates the rank value in a data range
according
to direction.
RATE(pmt, nper, pv, fv, point, guess rate)
Calculates the interest rate per a period of an annuity.
REPEAT(string, repeat number)
Returns a repeated character string of a string
of
repeating numbers. The repeate number for
the
REPEAT function must be natural number.
REPEATPERMUT(value, choose)
Calculates the number of permutations that can
be
selected from a value with adding to repeating.
REPLACE(string, start, number of characte
r, new string)
Replaces characters with a new text string.
RIGHT(string, value)
Returns the rightmost characters in a text string.
ROUND(value, digits)
Rounds a value to a specified number of digits.
ROUNDDOWN(value, digits)
Rounds down a value according to the number
of
digits.
ROUNDUP(value, digits)
Rounds up a value according to the number of digits.
SECOND(number)
Calculates the seconds from a number.
SIGN(value)
Returns 1 if the value is positive, zero if the value
is
0, and -1 if the value is negative.
SIMPAGGIDX(base period price, compare
period price)
Calculates a simple aggregated price index.
SIN(radians)
Returns the sine value of radians.
SINH(radians)
Returns the hyperbolic sine of radians.
SKEW(value1, value2, ...)
Calculates skewness of a distribution.
SLN(cost, salvage, life)
Calculates the straight-line depreciation of an
asset
for one period.