Filter
Top Products
Using mathematical functions 11-15
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
%TOTAL Percent total : (100)y/x. What percentage of x, is y.
%TOTAL(x, y)
Example
%TOTAL(20,50) returns 250
RAD→DEG Radians to degrees. Converts value from radians to
degrees.
RAD→DEG (value)
Example
RAD→DEG(π) returns 180