Rounds the input number up to the closest multiple of equal or greater value.

Usage

Ceiling(number, factor)

number (required) The number to be rounded.

factor [optional] The multiple to which the number will be rounded. The direction of rounding aligns with the positive or negative sign of the factor. The factor cannot be 0. Its default value is 1.

Examples

(1) Returns 4.

Ceiling(3.2)

(2) Returns -3.

Ceiling(-3.6)

(3) Returns the Ceiling for each row in the input column. 

Ceiling([Cost])

Screen_Shot_2020-11-30_at_3.11.57_PM.png

(4) Returns the Ceiling at a factor of 0.5 for each row in the input column.

Ceiling([Cost], 0.5)

Screen_Shot_2020-11-30_at_3.17.49_PM.png

(5) Returns the Ceiling at a factor of -0.25 for each row in the input column.

Ceiling([Cost], -0.25)

Screen_Shot_2020-11-30_at_3.22.55_PM.png

(6) Returns the Ceiling at a factor of 2 for each row in the input column.

Ceiling([Cost], 2)

Screen_Shot_2020-11-30_at_3.25.11_PM.png

See Also

Floor - Rounds the input number up to the closest multiple of equal or lesser value.

Round - Rounds the input number to the specified number of digits.