Sharp Zaurus SL-5500 Software Guide

CHAPTER 3:
HancomMobileSheet
61
DMIN(data, field, condition)
Calculates the smallest value in the field that
matches the condition.
DPROD(data, field, condition)
Calculates multiplication of data that matches the
condition.
DSTDEV(data, field, condition)
Calculates standard deviation of data that matches
the condition.
DSTDEVS(data, field, condition)
Calculates sample standard deviation of data that
matches the condition.
DSUM(data, field, condition)
Calculates summation of data that matches the
condition.
DVAR(data, field, condition)
Estimates variance of data that matches the
condition.
DVARS(data, field, condition)
Calculates sample variance of data that matches the
condition.
EXACT(string1, string2)
Compares two text strings and returns 1(true) if they
are the same one, returns 0(false) otherwise.
EXP(value)
Calculates the exponent for basis e.
EXPDIST(value, lambda, cumulative)
Calculates the probability from exponential
distribution.
FACT(value)
Returns the factorial of a value.
FDIST(value, freedom1, freedom2,cumulative)
Calculates the F probability distribution.
FDISTINV(probability,freedom1, freedom2)
Calculates the inverse of the F probability
distribution.
FINDTEXT(find what, within what)
Returns the first digit number of find what within
what.
FISHER(base period price, base period
quantity, compare period price, compare
period quantity, type)
Calculates the Fisher index.
FORECAST(value, independent range,
dependent range)
Calculates prediction of dependent variable at the
value of an independent variable by regression.
FREQUENCY(data range, interval hurdle
range)
Calculates the amount of data for each class from
data range by interval hurdle range. If data is less
than a hurdle range, it will increase the number of
that class.
FV(pmt, nper, rate, pv, point)
Calculates the future value of an investment based
on periodic, constant payments and a constant
interest rate.
FVDIFF(rate array, principal)
Calculates the future value of principal with applying
compound interest rate array.
GAMMA(value)
Calculates the gamma value.
GAMMADIST(value, alpha, beta, cumulative)
Calculates the probability of the gamma distribution.
GAMMALN(value)
Calculates the natural logarithm of the gamma
function.

Sharp Zaurus SL-5500 Specifications

General

Brand	Sharp
Model	Zaurus SL-5500
Category	PDA
Language	English