CEILING

Name

Ceiling

Description

Rounds a number up to the nearest multiple of a specified value.

Syntax

CEILING(value1, value2)

Remarks

Specify the number to round using the value1 argument. Specify the value to use as the rounding factor using the value2 argument. Use either both positive or both negative numbers for the arguments. Regardless of the sign of number, the number is rounded away from zero.

See also EVEN, FLOOR, INT, ODD, ROUND, ROUNDDOWN, ROUNDUP, and TRUNC.

Data Type

Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

CEILING(R1C2,1)
CEILING(C4,B2)
CEILING(B3,0.05)
CEILING(4.65,2)=6
CEILING(-2.78,-1)=-3