If the number is already an exact multiple, no rounding occurs and the original number is returned.
With no other input, CEILING.MATH will roundnumberup to the next integer.
Thesignificanceargument is the multiple to whichnumbershould be rounded.
The default value ofsignificanceis 1.
Themodeargument controls the direction negative values are rounded.
By default, CEILING.MATH rounds negative values uptoward zero.
Setting mode to 1 or TRUE changes behavior so that negative values are roundedaway from zero.
Examples
By default, CEILING.MATH rounds to the nearest integer, using asignificanceof 1.
Whenmodeis zero, or omitted, CEILING.MATH rounds negative numberstowardzero.
Whenmodeis 1 or TRUE, CEILING.MATH rounds negative numbersawayfrom zero.Modehas no effect on positive numbers.
The behavior is very similar, but CEILING.MATH provides explicit control over how negative numbers are rounded.
MROUND will round a number up or down, depending on the nearest multiple.
FLOOR Function
The Excel FLOOR function rounds a given number down to the nearest specified multiple.
FLOOR works like the MROUND function, but FLOORalways rounds down.
ROUND Function
The Excel ROUND function returns a number rounded to a given number of digits.
The ROUND function can round to the right or left of the decimal point.
ROUNDDOWN Function
The Excel ROUNDDOWN function returns a number rounded down to a given number of places.
CEILING works like theMROUND function, but CEILINGalways rounds up.
EVEN Function
The Excel EVEN function rounds numbers up to the next even integer.
ODD Function
The Excel ODD function returns the next odd integer after rounding a given number up.
Note that negative numbers becomemore negative.
For example, while INT(10.8) returns 10, INT(-10.8) returns -11.
For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) will return -3.
The TRUNC function does no rounding, it simply truncates as specified.
