Using mathematical functions 175
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)
Example:
%CHANGE(20,50) returns 150