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, |
| %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 |
Using mathematical functions |