Filter
Top Products
Using mathematical functions 10-17
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
ROUND Rounds value to decimal places. Accepts complex numbers.
ROUND(value,places)
Round can also round to a number of significant digits as
showed in example 2.
Examples
ROUND(7.8676,2) returns 7.68
ROUND (0.0036757,-3) returns 0.00368