Rounds a number up to the nearest integer or to the nearest multiple of significance.
Ta funkcja działa w Arkuszach Google tak samo jak w Excelu — ta sama składnia i argumenty.
CEILING.MATH(number, [significance], [mode])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)Wynik: 25
Rounds 22.25 up to the nearest multiple of 5.
=CEILING.MATH(-22.25, 5, 1)Wynik: -20
Rounds -22.25 towards zero using mode 1.
CEILING.MATH provides a mode parameter for better control over negative number rounding, whereas CEILING is older and less flexible.