Sharp Zaurus SL-5500 Software Guide

CHAPTER 3:
HancomMobileSheet
59
Function List
You must add "(double-quotation) to the beginning at to the end when you are
to input Srting data.
ABS(value)
Returns the absolute value of a number.
ACOS(cos value) Returns the radian value of the inverse cosine value.
ACOSH(hyperbolic cos value)
Returns the inverse hyperbolic cosine of a number
AND(logical1, logical2, ...)
Returns True(1) only if all arguments are true.
ASIN(sin value)
Returns the arc sine of a number in radians.
ASINH(hyperbolic sin value)
Returns the inverse hyperbolic sine of a number.
ATAN(tan value)
Returns the arc tangent of a number in radian value.
ATAN2(x value, y value)
Returns the arc tangent of the specified x and y
coordinates, and radian value of the inverse tangent
between X-ax and a line connected with a point
whose coordinate is (x value, y value).
ATANH(hyperbolic tan value)
Returns the inverse hyperbolic tangent of a number.
AVGRELIDX(base period, compare period)
Calculates average relative price index.
AVR(value1, value2,..)
Calculates the arithmetic mean of the values.
BETA(alpha, beta)
Calculates beta function value according to alpha
and beta.
BETADIST(value, alpha, beta)
Returns the ratio of the probability variable X(value)
against the unknown number 'alpha' and 'beta'.
BINOMIAL(trials, probability, cumulative)
Calculates the probability of binominal distribution.
CAUCHY(value, cumulative)
Calculates probability of Cauchy distribution.
CAUCHYINV(probability)
Calculates the inverse of the cumulative probability
from Caushy distribution.
CELL(type, range)
Returns information about the formatting, location, or
contents of the upper-left cell in a reference.
CHAR(value)
Returns the character specified by the value from the
character set.
CHISQR(value, freedom, cumulative)
Calculates probability of Chi-square distribution.
CHISQRINV(probability, freedom)
Calculates the inverse of the cumulative probability
from Chi-square distribution.
CHIVALUE(value, sample number, varianc
e of population)
Calculates Chisquare statistic. value is sample
variance.
CHOOSE(number, value1, value2,...)
Returns a value from value arguments, based on an
index number.
CODE(character) Returns a numeric code for the first character.

Sharp Zaurus SL-5500 Specifications

General

Brand	Sharp
Model	Zaurus SL-5500
Category	PDA
Language	English