ExcelHeroThe CEILING function
Rounds up to the next multiple of a step.
In German Excel: OBERGRENZE
How to write it
=CEILING(number, significance)- number
- The number to round.
- significance
- The step, like 0.5 or 12.
💡 Prices to the next 0.50, orders in full packs of 12.
Try it
Prices end in .50 or .00. Round 3.20 up to the next 0.50.
A
B
1
Cost
Price
2
3.2
=CEILING(A2, 0.5).