CEILING
The CEILING function returns the rounded up value of the specified number or node.
Syntax
CEIL(value) - > number
Arguments
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.
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
Remarks
Without using CEIL, the results would be:
Last updated