CEILING.MATH

Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more.

Video field
Math

In Google Sheets, CEILING.MATH is a function that rounds a given number up to the nearest integer or multiple of a specified significance based on the specified mode. The function takes one to three arguments:

number: This is the number that you want to round up to the nearest integer or multiple of a specified significance based on the specified mode. [significance]: This is an optional argument that specifies the significance to which you want to round the number. If this argument is omitted or 0, the function rounds the number up to the nearest integer. [mode]: This is an optional argument that specifies the rounding mode to use. If this argument is omitted or 0, the function rounds up. If it is set to -1, the function rounds down.

The CEILING.MATH function can be useful in various scenarios, such as when you want to calculate prices in retail or when you want to round up quantities in manufacturing or construction.

For example, if you want to round up the number 17 to the nearest multiple of 5, you can use the CEILING.MATH function like this:

=CEILING.MATH(17, 5)

The resulting number would be 20, which is the nearest multiple of 5 that is greater than or equal to 17.

If you omit the second argument or set it to 0, the function rounds the number up to the nearest integer. For example, if you want to round up the number 3.7 to the nearest integer, you can use the CEILING.MATH function like this:

=CEILING.MATH(3.7)

The resulting number would be 4, which is the nearest integer that is greater than or equal to 3.7.

You can also use the third argument to specify the rounding mode. For example, if you want to round down instead of up, you can use the CEILING.MATH function like this:

=CEILING.MATH(3.7, 1, -1)

The resulting number would be 3, which is the nearest integer that is less than or equal to 3.7.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!