Formulas and functions > Functions from A to Z > CEILING (round up to a multiple of base)

Syntax:

CEILING(Number, Base)

Description:

This rounds Number up (away from zero) to the nearest multiple of Base.

Positive numbers are rounded to the nearest multiple of Base that is larger than Number.

Negative numbers are rounded to the nearest multiple of Base that is smaller than Number.

Number and Base must have the same sign, otherwise the function returns a #NUM! error value.

Example:

CEILING(42.5, 1) returns 43

CEILING(-42.5, -1) returns -43

CEILING(21, 5) returns 25

CEILING(12.3456, 0.01) returns 12.35