Rounds a number up to the nearest integer or to the nearest multiple of significance.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
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)Sonuç: 3
Rounds 2.5 up to the nearest multiple of 1.
=CEILING(10, 3)Sonuç: 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.