The multiple to use for rounding is provided as thesignificanceargument.
If the number is already an exact multiple, no rounding occurs and the original number is returned.
The CEILING function takes twoarguments,number,andsignificance.Numberis the numeric value to round up.
Thesignificanceargument is the multiple to whichnumbershould be rounded.
See the example below.
CEILING works like theMROUND function, which also rounds to a given multiple.
However, unlike MROUND, which rounds to thenearestmultiple, the CEILING function rounds up to thenextmultiple.
Note: the CEILING function is officially listed as acompatibility function, replaced byCEILING.MATHandCEILING.PRECISE.
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.
