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

What is the CEILING function?
The CEILING function rounds numbers up or away from zero.
What does it do?
The CEILING function rounds numbers away from zero if the number is negative and significance is negative and towards zero if the number is negative and significance is positive.
What errors does it return?
The CEILING function returns a #VALUE! error if either argument is not a number.
How do I use the CEILING function?
The CEILING function requires two arguments: the number you want to round and the significance. To use the function, type: `=CEILING(number, significance)`.

## Make Better Decisions With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.

Drop CSV