ceil
ceil(number)
The CEIL function has the following arguments:
numberThe number or integer of which you want the ceiling value
The ceil function returns the smallest (closest to negative infinity) double value that is greater than or equal to the argument and is equal to a mathematical integer. The function will return a double precision number.
|
Formula |
Description |
Result |
|---|---|---|
|
ceil(0.9) |
Round up 0.9 to the nearest integer |
1.0 |
| ceil(-5.6) | Round up -5.6 to the nearest integer | -5.0 |
| ceil(10.0) | Round up 10 to the closest integer | 10.0 |