Hàm Google Sheets

ROUNDDOWN

Rounds a number down, toward zero.

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

ROUNDDOWN(number, num_digits)

The ROUNDDOWN function behaves like ROUND, except that it always rounds a number down. If num_digits is greater than 0, the number is rounded down to the specified number of decimal places; if it is 0 or negative, it rounds toward zero to the left of the decimal point.

Đối số

numberbắt buộcThe real number that you want to round down.
num_digitsbắt buộcThe number of digits to which you want to round the number.

Ví dụ

=ROUNDDOWN(3.14159, 3)

Kết quả: 3.141

Rounds 3.14159 down to three decimal places.

=ROUNDDOWN(314.159, -1)

Kết quả: 310

Rounds 314.159 down to the nearest ten.

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

How does ROUNDDOWN differ from ROUND?

ROUND rounds to the nearest value (up or down), while ROUNDDOWN always rounds toward zero.

Hàm liên quan

ROUND ROUNDUP FLOOR TRUNC