Sharp Zaurus ZR-5700

85
ABS( value ) Returns the absolute value of value .
Example: ABS(54) returns 54.
ABS(-54) returns 54.
EXP(
value ) Returns e raised to the power of
value . e is a constant equal to
approximately 2.718281828459045.
Example: EXP(4) returns the
approximate value of 54.5982.
INT(
value ) Returns the largest integer less than
value .
Example: INT(128.35) returns 128
while INT(-128.35) returns -129.
LN(
value ) Returns the natural logarithm of value.
Natural logs use base e. e is a
constant value equal to approximately
2.718281828459045.
Example: LN(A4) returns the natural
log of the value in cell A4.
LOG(value
, base ) Returns the common logarithm of a
value to the
base you specify or base
10 if
base is omitted.
Example: LOG(100) returns 2.
Log(A10, 3) returns the log base 3 of
the value in cell A10.
LOG10(value) Returns the base 10 logarithm of a
value.
Example: LOG10(86) returns
1.934498451.
MOD(
value , base )
Returns the remainder (modulus) after
value is divided by base .
Example: MOD (24, 9) returns 6.
PI() Returns the value of π.
Example: PI() returns 3.14159265...
RAND() Returns a pseudo random value
between 0 and 1.
Example: RAND() * 10 returns a
randomly generated value between
0 and 10.
ROUND(
value , digits )
Rounds value to a specified number
of digits.
Example: ROUND(23.25,1) returns
23.3. ROUND(23.247,2) returns 23.25.
ROUND(234.24,-2) returns 200.
SQRT(
value ) Returns the square root of value .
Example: SQRT(30) returns 5.47723.