1. Docs
  2. Formulas
  3. Functions

CEIL

Rounds the input up to the nearest whole number.

Categories: Numbers

Syntax

CEIL(number)

Examples

Example 1

Input

1
{
2
"my_action": {
3
"message": 1.2
4
}
5
}

Formula

CEIL(my_action.message)

Output

2

Example 2

Input

1
{
2
"my_action": {
3
"message": 2
4
}
5
}

Formula

CEIL(my_action.message)

Output

2

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

Input

1
{
2
"my_action": {
3
"message": "3.5"
4
}
5
}

Formula

CEIL(my_action.message)

Output

4

Sample actions

Event Transform
My Action
Event Transform
CEIL

Select an action to inspect

You can also click "Copy actions" and paste them in your Tines story to see how they work.

Was this helpful?