Excel CEILING Function

Excel CEILING Function

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.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas
Logo