Rounds a number down to the nearest multiple of significance.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
FLOOR(number, significance)The FLOOR function rounds a number down, toward zero, to the nearest multiple of the specified significance. It is commonly used for rounding prices or quantities to a specific increment.
=FLOOR(2.5, 1)결과: 2
Rounds 2.5 down to the nearest multiple of 1.
=FLOOR(17, 5)결과: 15
Rounds 17 down to the nearest multiple of 5.
The function returns the number unchanged.
Yes, but the rounding behavior depends on the sign of the number and the significance.