Hàm Google Sheets

FLOOR.MATH

Rounds a number down to the nearest integer or to the nearest multiple of significance.

Tạo công thức bằng AI Cùng hàm trong Excel

Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.

Cú pháp

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.

Đối số

numberbắt buộcThe number you want to round.
significancetùy chọnThe multiple to which you want to round. Defaults to 1.
modetùy chọnThe direction to round negative numbers (0 or omitted rounds toward negative infinity).

Ví dụ

=FLOOR.MATH(6.7)

Kết quả: 6

Rounds 6.7 down to the nearest integer.

=FLOOR.MATH(-5.2, 2)

Kết quả: -6

Rounds -5.2 down to the nearest multiple of 2.

Câu hỏi thường gặp

How does FLOOR.MATH differ from FLOOR?

FLOOR.MATH provides a mode argument to control how negative numbers are rounded, whereas FLOOR does not.

Hàm liên quan

FLOOR CEILING.MATH ROUNDDOWN MROUND