CEIL returns the value of a specified variable, rounded up to the next integer value.
SYNTAX:
CEIL(Cx)
where :
Cx is a conditional variable x
NOTES:
This Function always rounds up.
EXAMPLES:
V71= CEIL(V70)
Returns the value of V70 rounded up to the next integer value.
In the example above, note the three red arrows:
-
A value that would normally round to 2 is rounded up to 3.
-
A value that would normally round to -3 is rounded up to -2.
-
A value that is only 1 ten-thousandth above 3 is still rounded up to 4.