Rounds a number down to the nearest integer or to the nearest multiple of significance.
Söz dizimi
FLOOR.MATH(number, [significance], [mode])Bağımsız değişkenler
numberzorunlu
The number you want to round.
significanceisteğe bağlı
The multiple to which you want to round. Defaults to 1.
modeisteğe bağlı
The direction to round negative numbers (0 or omitted rounds toward negative infinity).
The FLOOR.MATH function rounds a number down toward zero or away from zero, depending on the mode. It is more flexible than the standard FLOOR function because it allows you to control the rounding direction for negative numbers.
=FLOOR.MATH(6.7)→6Rounds 6.7 down to the nearest integer.
=FLOOR.MATH(-5.2, 2)→-6Rounds -5.2 down to the nearest multiple of 2.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =FLOOR.MATH( and input the number, followed by optional significance and mode arguments.
Complete the function
Close the parenthesis and press Enter to calculate the value.
FLOOR.MATH provides a mode argument to control how negative numbers are rounded, whereas FLOOR does not.