CEILING for a .99 price ending
Round up to the next whole unit, then take a penny off.
Task:
Retail prices end in .99. In C2:C6 turn each calculated price into the next .99 price at or above it — 7.40 becomes 7.99 and 12.00 becomes 11.99.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of CEILING, FLOOR
0/4The same formula in the other shapes it takes at work.
- CEILING and FLOOR Functions
Round numbers up or down to specific multiples.
CoreIntermediate - FLOOR to the quarter hour
The multiple can be a fraction: bill time in completed quarter hours.
Intermediate - CEILING for a .99 price ending
Round up to the next whole unit, then take a penny off.
Intermediate - CEILING to buy whole packs
You need 130 screws; they come in boxes of 50. What does that cost?
Advanced
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Product | Calculated price | Shelf price |
| 2 | Candle | 7.4 | |
| 3 | Vase | 12 | |
| 4 | Frame | 18.05 | |
| 5 | Coaster set | 4.99 | |
| 6 | Throw | 31.5 |
What this exercise teachesMay contain the answer
Price endings are rounding plus an offset. Rounding up first keeps the margin — a price never drops more than a penny below its calculated value — and the offset gives the ending. A calculated 4.99 stays 4.99.