Hàm Google Sheets

CEILING

Rounds a number up 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

CEILING(number, significance)

The CEILING function rounds a given number away from zero to the nearest multiple of the specified significance. It is commonly used for pricing or inventory calculations where values must be rounded up to a specific unit.

Đối số

numberbắt buộcThe value you want to round.
significancebắt buộcThe multiple to which you want to round.

Ví dụ

=CEILING(2.5, 1)

Kết quả: 3

Rounds 2.5 up to the nearest multiple of 1.

=CEILING(10, 3)

Kết quả: 12

Rounds 10 up to the nearest multiple of 3, which is 12.

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

What happens if the number is already a multiple of significance?

The function returns the number unchanged.

Does CEILING work with negative numbers?

Yes, but it rounds away from zero, meaning it becomes more negative.

Hàm liên quan

FLOOR ROUNDUP ROUND