Rounds a number down to the nearest integer or to the nearest multiple of significance.
구문
FLOOR.MATH(number, [significance], [mode])인수
number필수
The number you want to round.
significance선택
The multiple to which you want to round. Defaults to 1.
mode선택
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.