CEILING

Round a number up to the nearest specified multiple

Sponsored Link

CEILING

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.

Sponsored Link

0 votes. 0 / 5