If the number is already an exact multiple, no rounding occurs and the original number is returned.

With no other input, FLOOR.MATH will roundnumberdown to the next integer.

Thesignificanceargument is the multiple to whichnumbershould be rounded.

Excel MROUND function

The default value ofsignificanceis 1.

Themodeargument controls the direction negative values are rounded.

By default, FLOOR.MATH rounds negative valuesawayfrom zero.

Excel FLOOR function

Settingmodeto 1 or TRUE changes behavior so that negative values are roundedtoward zero.

Examples

By default, FLOOR.MATH rounds to the nearest integer, using asignificanceof 1.

Whenmodeis omitted, FLOOR.MATH rounds negative numbersawayfrom zero.

Excel ROUND function

Whenmodeis set to TRUE, FLOOR.MATH rounds negative numberstowardzero.Modehas no effect on positive numbers.

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.

Excel ROUNDDOWN function

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.

Excel ROUNDUP function

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.

Excel CEILING function

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.

Excel EVEN function

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.

Excel ODD function

Excel INT function

Excel TRUNC function