<< Click to Display Table of Contents >> CEILING (round up to a multiple of base) |
Syntax:
CEILING(Number, Base)
Description:
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
See also: