---
title: CEIL
url: https://www.tines.com/docs/formulas/functions/ceil/
kind: formula-function
---

*[tines.com](https://www.tines.com/llms.txt) › [Docs](https://www.tines.com/llms.txt) › [Formulas](https://www.tines.com/llm/docs/formulas.md) › [Functions](https://www.tines.com/llm/docs/formulas/functions.md)*

# CEIL

*[View on tines.com](https://www.tines.com/docs/formulas/functions/ceil/)*

Rounds the input up to the nearest whole number.

**Categories:** Numbers

## Syntax

```
CEIL(number)
```

## Examples

### Example 1

Input:

```json
{
  "my_action": {
    "message": 1.2
  }
}
```

Formula:

```
CEIL(my_action.message)
```

Output:

```json
2
```

### Example 2

Input:

```json
{
  "my_action": {
    "message": 2
  }
}
```

Formula:

```
CEIL(my_action.message)
```

Output:

```json
2
```

### Example 3: CEIL will also work on text that only contains a number:

Input:

```json
{
  "my_action": {
    "message": "3.5"
  }
}
```

Formula:

```
CEIL(my_action.message)
```

Output:

```json
4
```

## Sample actions

```json
{
  "standardLibVersion": "13",
  "actionRuntimeVersion": "2",
  "agents": [
    {
      "disabled": false,
      "name": "My Action",
      "description": "",
      "options": {
        "mode": "message_only",
        "loop": false,
        "payload": {
          "value1": 1.2,
          "value2": 2,
          "value3": "3.5"
        }
      },
      "position": {
        "x": 2625,
        "y": 2055
      },
      "type": "eventTransformation",
      "timeSavedUnit": "minutes",
      "timeSavedValue": 0,
      "monitorAllEvents": false,
      "monitorFailures": false,
      "monitorNoEventsEmitted": null,
      "form": null
    },
    {
      "disabled": false,
      "name": "CEIL",
      "description": "",
      "options": {
        "mode": "message_only",
        "loop": false,
        "payload": {
          "value1": "=CEIL(my_action.value1)",
          "value2": "=CEIL(my_action.value2)",
          "value3": "=CEIL(my_action.value3)"
        }
      },
      "position": {
        "x": 2625,
        "y": 2145
      },
      "type": "eventTransformation",
      "timeSavedUnit": "minutes",
      "timeSavedValue": 0,
      "monitorAllEvents": false,
      "monitorFailures": false,
      "monitorNoEventsEmitted": null,
      "form": null
    }
  ],
  "links": [
    {
      "sourceIdentifier": 0,
      "receiverIdentifier": 1
    }
  ],
  "diagramNotes": []
}
```