The Ceiling() function rounds a number up to an integral value (integer number without decimals) larger than or equal to the given number.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the closest integral value that is larger than or equal to number.
Returns Invalid expression if the parameter is not a valid number.
| Name | Type | Required | Description |
|---|---|---|---|
| Function call | Result |
|---|---|
number
numeric
a number
Ceiling(5)
5
Ceiling(5.0001)
6
Ceiling(123.123)
124
Ceiling(-123.89)
-123