Functions
CEILING
Round up to nearest multiple of significance
Try it
When to use it
When should I use CEILING instead of ROUNDUP?
CEILING rounds up to the nearest multiple of a factor you choose, such as the next 5 or next 0.25. ROUNDUP only rounds up to a number of decimal places. Use CEILING for pricing tiers, packaging units, or time blocks.
How do I round a price up to the next 5 cents?
Use CEILING(price, 0.05). It pushes any amount up to the nearest 0.05 boundary, which is common in retail price formatting.
Use cases
Round an order quantity up to a case of 5
Round a price up to the nearest 5 cents
Used in
Syntax
CEILING(number, significance)Examples
=CEILING(23.25,0.1) // => 23.3
=CEILING(23.25,1) // => 24
=CEILING(22,5) // => 25