CEIL

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
Next item
DIVIDE (/)