How to round up to the nearest 5 or 10
✓ Verified in LibreOffice 25.8.7.3Push values up to clean steps — pricing, order quantities, capacity planning.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =CEILING(A2,5) | Always rounds UP to a multiple of 5. FLOOR rounds down; MROUND rounds to nearest. |
| Google Sheets | =CEILING(A2,5) | Identical. |
| LibreOffice Calc | =CEILING(A2,5) | Identical. |
How it works
CEILING(23,5) climbs to the next multiple of 5 → 25; CEILING(23,10) gives 30. FLOOR is the mirror (down to 20), and MROUND goes to whichever multiple is closer. The trio also powers price psychology: =CEILING(A2,5)-0.01 turns 23 into 24.99. Exact multiples stay put — CEILING(25,5) is 25. For negative numbers prefer CEILING.MATH (Excel/LO), which defines the direction explicitly; classic CEILING errors on mixed signs in older Excel.
Verified, not just documented
We ran =CEILING(A2,5) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 25 — exactly the expected result. Every formula here is confirmed by actually executing it.