# CEILING

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

### Syntax

CEIL(value) - > number

### Arguments

<table><thead><tr><th width="159">Arguments</th><th width="148">Datatype</th><th>Description</th></tr></thead><tbody><tr><td>value</td><td>Number/Node reference</td><td>The value or the node name that has the values to be rounded up.</td></tr></tbody></table>

### 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.

<table><thead><tr><th width="318.4339963833635">Periods</th><th width="93">Jan</th><th width="92">Feb</th><th width="84">Mar</th></tr></thead><tbody><tr><td><mark style="color:green;">Raw material available per box</mark></td><td>2</td><td>2</td><td>2</td></tr><tr><td><mark style="color:orange;">Raw material used per box</mark> </td><td>1.25</td><td>1.25</td><td>1.25</td></tr><tr><td><mark style="color:purple;">Demand</mark></td><td>20</td><td>25</td><td>30</td></tr></tbody></table>

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

<mark style="color:blue;">**`CEIL`**</mark>**`((`**<mark style="color:blue;">**`PRODUCT`**</mark>**`(`**<mark style="color:purple;">**`[Demand]`**</mark>**`,`**<mark style="color:orange;">**`[Raw material used per box]`**</mark>**`))/`**<mark style="color:green;">**`[Raw material available per box]`**</mark>**`)`**

### **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 |