Description
The CEIL function rounds a number away from zero to the nearest whole number.
Usage
CEIL(value)
| Argument | Type | Required | Description |
|---|---|---|---|
| value | Numeric | Yes | The value to round |
Result
The nearest whole number when rounding up from the given value.
Example
If you are collecting data on household water needs in liters, you may want to calculate the number of 5L jerrycans the household would require to transport the water in one trip.
For example, if you a household requires 2.5 liters per day, you might say that they need half a 5-liter jerry can. Of course, you can't cut a jerrycan in half, so you would need to round up to one whole jerry can. You could use the following formula:
CEIL(HH_WATER_NEED_IN_LITERS / 5)
The following table shows the results for different values of HH_WATER_NEED_IN_LITERS:
| HH_WATER_NEED_IN_LITERS | CEIL(HH_WATER_NEED_IN_LITERS / 5) |
|---|---|
| 0 | 0 |
| 1.5 | 1 |
| 4.9 | 1 |
| 5.0 | 1 |
| 5.1 | 2 |
| 9.0 | 2 |
| 10.0 | 2 |
| 11 | 3 |