User Manual

Page 4-122 Windows CE
Fact(number) Returns the factorial of a number. The number must be
nonnegative number.
Example: Fact(5) equals 120.
Floor(number, significance) Rounds the number down, toward zero, to the
nearest multiple of the significance.
Example: Floor(3.5, 1) equals 3.
Int(number) Rounds a number down to the nearest integer. Example:
Int(1.7) equals 1.
Ln(number) Returns the natural logarithm of a number.
Example: Ln(Exp(2)) equals 2.
Log(number, base) Returns the logarithm of a number to the base you
specify. If the base is omitted, it is assumed to be 10.
Example: Log(100, 10) equals 2.
Log10(number) Returns the logarithm (base 10) of a number.
Example: Log10(100) equals 2.
Mod(number, divisor) Returns the remainder after the number is divided
by the divisor.
Example: Mod(5, 2) equals 1.
Odd(number) Returns the number rounded up to the nearest odd integer.
Example: Odd(2) equals 3.
Pi() Returns the number 3.14159265358979, the mathematical constant PI.
Power(number, power) It raises the number to the power. You can also use
the “^” operator (e.g. 4^2).
Example: Power(4,2) equals 16.
Product(number, number, ...) Multiplies all the numbers given as
arguments and returns the product.
Example: A1 contains 2, Product(A1, 5) equals 10.
Radians(number) Converts degrees to radians.
Example: Radians(180) equals 3.14159.
Rand() Returns a random number greater than or equal to 0 and less than 1.
A new number is returned every time the workbook is recalculated.
Round(number, number) Rounds a number to the specified number of
digits. Example: Round(5.46, 1) equals 5.5.
RoundDown(number, numDigits) Rounds the number down, toward
zero, to the specified number of digits.
Example: RoundDown(40.8, 0) equals 40.
RoundUp(number, numDigits) Rounds the number up, away from zero,
to the specified number of digits.
Example: RoundUp(39.1, 0) equals 40.