Rounds a number up to the nearest integer or to the nearest multiple of significance.
Синтаксис
CEILING(number, significance)Аргументы
numberобязательно
The value you want to round.
significanceобязательно
The multiple to which you want to round.
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)→3Rounds 2.5 up to the nearest multiple of 1.
=CEILING(10, 3)→12Rounds 10 up to the nearest multiple of 3, which is 12.
Select the cell
Click on the cell where you want the result to appear.
Enter the function
Type =CEILING( followed by the number and the significance, then close the parenthesis.
Execute
Press Enter to calculate the rounded value.
The function returns the number unchanged.
Yes, but it rounds away from zero, meaning it becomes more negative.