CEILING

CEILING(value)[source]

Rounds a number or array of numbers up to the nearest integer.

The CEILING function evaluates the input value and returns the smallest integer greater than or equal to it. If an array of numbers is provided, each element is rounded up individually. If the input is blank or in an error state, the formula evaluates to an error.

Parameters:

value (Operand | float) – The number or array of numbers to compute the ceiling of. If blank or in an error state, the formula will evaluate to an error.

Return type:

Formula

Returns:

The integer value(s) representing the ceiling of the input. The result matches the input type: scalar input returns a single integer, array input returns an integer array.

Raises:

ValueError – If value is not of type DECIMAL or DECIMAL_ARRAY.

Examples

Rounding a single value:

ROUND(3.6)
# Returns 4

Rounding an array of values:

ROUND([1.2, 3.0, 4.5])
# Returns [2, 3, 5]

``value`` — accepted types

  • DECIMAL

  • DECIMAL_ARRAY

Return types

  • INTEGER

  • INTEGER_ARRAY