The multiple to use for rounding is provided as thesignificanceargument.
The MROUND function takes twoarguments,numberandsignificance.Numberis the numeric value to round.
Thesignificanceargument is the multiple to whichnumbershould be rounded.
Nearest 15 minutes
MROUND can be used to round time.
CEILING works like theMROUND function, but CEILINGalways rounds up.
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.
MROUND will round a number up or down, depending on the nearest multiple.
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.
