ROUNDDOWN rounds the value of a specified variable or expression down, toward zero..
SYNTAX:
ROUNDDOWN(Cx or Exp, DecimalPlaces)
where :
Cx is a conditional variable x
Exp is a Expression
Decimal Places specifies the number of places after the decimal to round the number to
NOTES:
See also ROUND, CEIL, SROUND, and SDIGITS.
EXAMPLES:
Example 1:
V131 = ROUNDDOWN(C70, 1)
Variable 131 will contain the data in variable 70 rounded to the nearest integer:
| V70 |
V131 |
| .333 |
0.3 |
|
.28 |
0.2 |
| 1.234 |
1.2 |
| -1.19 |
-1.1 |