Rounds a number up to the nearest integer or to the nearest multiple of significance.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
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.
=CEILING(2.5, 1)ผลลัพธ์: 3
Rounds 2.5 up to the nearest multiple of 1.
=CEILING(10, 3)ผลลัพธ์: 12
Rounds 10 up to the nearest multiple of 3, which is 12.
The function returns the number unchanged.
Yes, but it rounds away from zero, meaning it becomes more negative.