# CEILING

Formulas / CEILING
Round a number up to the nearest multiple specified.
`=CEILING(number,significance)`
• number - required, the number to round up
• significance - required, the multiple to use when rounding (can be provided as a number or text of a time)

## Examples

• `=CEILING(10,3)`

The CEILING function rounds a number up to the nearest multiple of a supplied number. For example, this returns 12. This is because 12 is the next closest multiple of 3 to 10.

• `=CEILING(36,7)`

The CEILING function can be used to round to any multiple of a number. For example, this formula returns 42. This is because the number 42 is the next closest multiple of 7 to the number 36.

• `=CEILING(309,25)`

The CEILING function can also be used to round up to a whole dollar amount. For example, this formula returns 325. This is because the number 325 is the next closest multiple of 25 to the number 309.

• `=CEILING(610,100)`

The CEILING function can be used to round up to a multiple of 100. For example, the above formula returns 700. This is because the number 700 is the next closest multiple of 100 to 610.

• `=CEILING(-5.4,1)`

The CEILING function can be used to round negative numbers up. This example returns -5. This is because the number -5 is the next closest multiple of 1 to -5.4

## Summary

The CEILING function rounds a given number up to the nearest multiple of significance, requiring a number argument as the value to be rounded.

• The CEILING function rounds a number up to the next highest multiple specified in the function.
• The CEILING function is part of the Sourcetable functions and is formally listed as a compatibility function.

The CEILING function requires two arguments: the number you want to round and the significance. To use the function, type: `=CEILING(number, significance)`.