The CEILING() function allows you to round a number up to the nearest integer.
Numeric function name:
CEILING()
Syntax
CEILING(value)ℹ Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to be added between quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
value |
Numeric value to round. |
Example
CEILING(4.3)Result: 5
Notes
- CEILING() always rounds up to the next highest integer.
- If the value is already an integer, it is returned as is.
Return type
The function returns a number.
The output type format of the result can be set in the output field options of the formula editor. For more details, see Output format options in the Formula column article.