Rounds a number up to the nearest integer or to the nearest multiple of significance.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
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)Kết quả: 25
Rounds 22.25 up to the nearest multiple of 5.
=CEILING.MATH(-22.25, 5, 1)Kết quả: -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.