Ceiling()

Working with Formulas > Functions Used in Formulas > Numeric Functions > Ceiling()

CEILING() returns the smallest number, to the specified precision, that is greater than or equal to the input number. If no precision is specified, CEILING() returns the smallest integer greater than or equal to the input number.

Function Format

CEILING(number [, precision]) 

Return Value

CEILING() returns a numeric value 

Examples

CEILING(10.333) = 11 

CEILING(-10.333) = -10 

CEILING(10.333, 2) = 10.34 

CEILING(-10.333, 2) = -10.33 

CEILING(1024, -2) = 1100