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.