Add a percentage to a price
Price × (1 + rate), with the rate kept in one cell.
Task:
Prices go up by the rate in B1 next month. In C4:C8 give each product's new price, reading the rate from B1 so it can be changed later.
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of Percentage Calculations
0/4The same formula in the other shapes it takes at work.
- Percentage Calculations
Calculate percentages using basic arithmetic.
CoreIntermediate - Percentage change
New minus old, divided by old — and why the order matters.
Intermediate - Add a percentage to a price
Price × (1 + rate), with the rate kept in one cell.
Beginner - Take a percentage back out
Recover the net price from a gross one — and why subtracting 20% is wrong.
Intermediate
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 | Increase | 0.08 | |
| 2 | |||
| 3 | Product | Price | New price |
| 4 | Desk lamp | 42 | |
| 5 | Office chair | 189 | |
| 6 | Monitor arm | 65 | |
| 7 | Footrest | 28 | |
| 8 | Cable tray | 15 |
What this exercise teachesMay contain the answer
Price plus price times rate gives the same number, but =B4*(1+$B$1) says the rule once and reads the rate from one place. When the increase changes to 6%, one cell changes and every new price follows.