CEILING

The CEILING function returns the rounded up value of the specified number or node.

Syntax

CEIL(value) - > number

Arguments

Arguments	Datatype	Description
value	Number/Node reference	The value or the node name that has the values to be rounded up.

Example

Consider the below example where we have raw material consumption data. The objective is to find out the number of boxes of raw material that we have consumed.

Periods	Jan	Feb	Mar
Raw material available per box	2	2	2
Raw material used per box	1.25	1.25	1.25
Demand	20	25	30

To achieve this, the following formula should be written in the [No. of raw material boxes used] node.

CEIL((PRODUCT([Demand],[Raw material used per box]))/[Raw material available per box])

Result

Periods	Jan	Feb	Mar
No. of raw material boxes used	13.00	16.00	19.00

Remarks

Without using CEIL, the results would be:

Periods	Jan	Feb	Mar
No. of raw material boxes used	12.50	15.625	18.75