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 FLOOR function takes twoarguments,numberandsignificance.Numberis the numeric value to round down.
Thesignificanceargument is the multiple to whichnumbershould be rounded.
See the example below.
FLOOR works like theMROUND function, but unlike MROUND, which rounds to thenearestmultiple, FLOORalways rounds down.
Note: the FLOOR function is officially listed as acompatibility function, replaced byFLOOR.MATHandFLOOR.PRECISE.
MROUND will round a number up or down, depending on the nearest multiple.
CEILING Function
The Excel CEILING function rounds a given numberupto the nearest specified multiple.
CEILING works like theMROUND function, but CEILINGalways rounds up.
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.
FLOOR works like the MROUND function, but FLOORalways rounds down.
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.
