Rounds a number up to the nearest integer or to the nearest multiple of significance.
Синтаксис
CEILING.MATH(number, [significance], [mode])Аргументы
numberобязательно
The number to round.
significanceнеобязательно
The multiple to which you want to round. Defaults to 1.
modeнеобязательно
Determines the direction of rounding for negative numbers.
CEILING.MATH rounds a number up to the nearest integer or the nearest multiple of significance. Unlike the standard CEILING function, this function provides more control over how negative numbers are rounded using the mode argument.
=CEILING.MATH(22.25, 5)→25Rounds 22.25 up to the nearest multiple of 5.
=CEILING.MATH(-22.25, 5, 1)→-20Rounds -22.25 towards zero using mode 1.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =CEILING.MATH() and provide the number and optional significance.
Press Enter
Press Enter to calculate the rounded value.
CEILING.MATH provides a mode parameter for better control over negative number rounding, whereas CEILING is older and less flexible.