Ceiling
Returns the closest integral value that is larger than or equal to number
.
Returns Invalid expression
if the parameter is not a valid number.
This function uses 32-bit Integers, therefore the range of valid parameters is
-2147483648 and +2147483648
Syntax
Parameters
Name
Type
Required
Description
number
numeric
a number
Examples
Function call
Result
Ceiling(5)
5
Ceiling(5.0001)
6
Ceiling(123.123)
124
Ceiling(-123.89)
-123
Last updated
Was this helpful?