CEILING function
Synopsis
This function
returns the smallest whole number greater than or equal to the
specified number. Essentially, this function rounds the specified
number upwards to the closest whole number.
Variations
CEILING (
Number)
Returns the smallest whole number
greater than or equal to the specified number.
Details |
Examples |
Details and examples
Parameters
Number
Specifies the number to round upwards.
Supported types: Numeric.
Returns
Examples
| 1. |
The following example returns 5.
CEILING(4.3)
|
| 2. |
The following example also returns 5.
CEILING(5)
|