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 |
Last updated