Excel CEILING Function

Excel CEILING Function


Round a number up to the nearest specified multiple

Return value 

A rounded number.


=CEILING (number, multiple)


  • 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.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas