Filter
Top Products
Using mathematical functions 13-15
with a decimal fraction) to H.MMSSs format (time or
angle up to fractions of a second).
→HMS(x.x)
Example
→HMS(8.5) returns 8.3
INT Integer part.
INT(value)
Example
INT(23.2) returns 23
MANT Mantissa (significant digits) of value.
MANT(value)
Example
MANT(21.2E34) returns 2.12
MAX Maximum. The greater of two values.
MAX(value1, value2)
Example
MAX(210,25) returns 210
MIN Minimum. The lesser of two values.
MIN(value1, value2)
Example
MIN(210,25) returns 25
MOD Modulo. The remainder of value1/value2.
value1 MOD value2
Example
9 MOD 4 returns 1
% x percent of y; that is, x/100*y.
%(x, y)
Example
%(20,50) returns 10
%CHANGE Percent change from x to y, that is, 100(y–x)/x.
%CHANGE(x, y)
HP 39gs English.book Page 15 Wednesday, December 7, 2005 11:24 PM