The FLOOR.MATH function in Excel is a powerful tool designed to round numbers down towards zero, either to the nearest whole integer or to a specified multiple of significance. This function is particularly useful in calculations where you want to avoid fractions or where you need to adhere to certain numerical rounding standards.

Syntax

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

• number: The numeric value that you want to round down.
• significance: (Optional) The multiple to which you want to round the number. If omitted, the default is 1.
• mode: (Optional) A value that determines the direction of rounding when number is negative. If omitted, the default is 0 (rounds towards zero).

Example #1

=FLOOR.MATH(2.7)

This function call rounds the number 2.7 down to the nearest integer, resulting in 2.

Example #2

=FLOOR.MATH(5.5, 1)

This example rounds 5.5 down to the nearest multiple of 1, yielding a result of 5.

Example #3

=FLOOR.MATH(-2.3, 0.5, 1)

In this case, the function rounds -2.3 down to the nearest multiple of 0.5, producing -2.5 as the output when specifying that rounding is always toward negative infinity.

Error handling

• NUM! Error occurs when the significance is zero or a non-numeric value.
• VALUE! Error happens if number is non-numeric.

Conclusion

Utilizing the FLOOR.MATH function can greatly enhance the precision of numerical data handling in Excel. By allowing control over how numbers are rounded down, this function provides flexibility for various financial, statistical, and engineering applications. Understanding its parameters ensures that you can apply it effectively in your calculations.