Google Sheets Function

CEILING.MATH

Rounds a number up to the nearest integer or to the nearest multiple of significance.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

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.

Arguments

numberrequiredThe number to round.
significanceoptionalThe multiple to which you want to round. Defaults to 1.
modeoptionalDetermines the direction of rounding for negative numbers.

Examples

=CEILING.MATH(22.25, 5)

Result: 25

Rounds 22.25 up to the nearest multiple of 5.

=CEILING.MATH(-22.25, 5, 1)

Result: -20

Rounds -22.25 towards zero using mode 1.

FAQ

How does CEILING.MATH differ from CEILING?

CEILING.MATH provides a mode parameter for better control over negative number rounding, whereas CEILING is older and less flexible.

Related functions

CEILING FLOOR.MATH ROUNDUP