Rounds a number up to the nearest integer or to the nearest multiple of significance.
이 함수는 Google Sheets에서도 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.