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.