ROUNDUP rounds the value of a specified variable or expression up, away from zero.
SYNTAX:
ROUNDUP(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, ROUNDDOWN, CEIL, SROUND, and SDIGITS.
EXAMPLES:
Example 1:
V131 = ROUNDUP(C70, 0)
Variable 131 will contain the data in variable 70 rounded to the nearest integer:
V70 |
V131 |
1.2 |
2 |
2.9 |
3 |
<2.7 |
<3 |
-1.19 |
-2 |