_CEIL

The _CEIL function rounds a numeric value up to the next whole number or INTEGER value.

Syntax

result = _CEIL(expression)

• _CEIL returns he smallest integral value that is greater than the numerical expression (as a floating-point value).
• This means that _CEIL rounds up for both positive and negative numbers.

Availability

• Version 1.000 and up.

Example(s)

Displaying the rounding behavior of INT, CINT and FIX vs _CEIL.

PRINT INT(2.5), CINT(2.5), FIX(2.5), _CEIL(2.5)
PRINT INT(-2.5), CINT(-2.5), FIX(-2.5), _CEIL(-2.5)

 2        2         2         3
-3       -2        -2        -2

See Also

• INT, FIX
• CINT, CLNG,
• CSNG, CDBL
• _ROUND