Rounds a number up to the nearest integer or to the nearest multiple of significance.
Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.
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)Resultaat: 3
Rounds 2.5 up to the nearest multiple of 1.
=CEILING(10, 3)Resultaat: 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.