Purpose
Round a number up to the nearest specified multiple
Return value
A rounded number.
Syntax
=CEILING (number, multiple)
Arguments
- number – The number that should be rounded.
- multiple – The multiple to use when rounding.
Usage notes
CEILING works like the MROUND function, but CEILING always rounds up, away from zero.
CEILING can be a can be a useful function to set pricing after currency conversion, discounts, etc.