CEILING function

Microsoft Office ShapeSheet

CEILING function

See also

Rounds a number away from 0 (zero) to the next instance of multiple. If multiple is not specified, the number rounds away from 0 to the next integer.

Syntax

CEILING(number, multiple)

Remarks

Number and multiple must have the same signs, or a #NUM! error is returned. If either number or multiple cannot be converted to a value, a #VALUE! error is returned. If either number or multiple is 0, the result is 0.

Example 1

CEILING(3.7)

Equals 4.

Example 2

CEILING(-3.7)

Equals -4.

Example 3

CEILING(3.7, 0.25)

Equals 3.75.