Loading ...
Loading ...
Loading ...
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.
Loading ...
Loading ...
Loading ...