Article updated on March 09, 2018

The FLOOR.MATH function rounds a number down to the nearest integer or to the nearest multiple of significance.

Formula in cell E3:


Excel Function Syntax

FLOOR.MATH(number, [significance], [mode])


number Required. The number to be rounded down.
[significance] Optional. The multiple to which you want to round.
[mode] Optional.  The direction (toward or away from 0) to round negative numbers.