Rounds a number up to the nearest integer or to the nearest multiple of significance.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
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)結果: 25
Rounds 22.25 up to the nearest multiple of 5.
=CEILING.MATH(-22.25, 5, 1)結果: -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.