CEIL function rounds a number away from zero to the nearest whole number.
|value||Numeric||Yes||The value to round|
The nearest whole number when rounding up from the given value.
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