CEILING() : round a number up

The CEILING() function rounds a number up to the nearest integer, and returns an integer.

CEILING() always rounds up, to the next highest integer. If the value is already an integer, it is returned as is.

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

1 value Numeric value to round.

The output format (integer or decimal) can be configured in the output field options of the formula editor. See Output format options in the Formula column article.

Examples

Decimal number

CEILING(4.3)

Result: 5

Go further

FLOOR()

The reverse operation: round a number down to the nearest integer.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.