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, | |
| %CHANGE(x, y) |
|
Using mathematical functions |