Rounds a number down to the nearest integer or to the nearest multiple of significance.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
FLOOR.MATH(number, [significance], [mode])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)결과: 6
Rounds 6.7 down to the nearest integer.
=FLOOR.MATH(-5.2, 2)결과: -6
Rounds -5.2 down to the nearest multiple of 2.
FLOOR.MATH provides a mode argument to control how negative numbers are rounded, whereas FLOOR does not.