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.
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.