If the number is already an exact multiple, no rounding occurs and the original number is returned.
With no other input, CEILING.PRECISE will roundnumberup to the next integer.
Thesignificanceargument is the multiple to whichnumbershould be rounded.
The default value ofsignificanceis 1.
Examples
By default, CEILING.PRECISE rounds up to the next integer, with asignificanceof 1.
If you need control over rounding of negative values up or down, see theCEILING.MATH function.
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.
