Months to a savings goal with ROUNDUP
PremiumIn D2, work out how many months it takes to save up for the vacation. Divide the price by the monthly savings and round up with ROUNDUP. Part of a month still means waiting a whole extra month.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Goal | Price | Saved per month | Months | ||
| 2 | Vacation | 12500 | 1500 | |||
| 3 | Laptop | 9000 | 750 | |||
| 4 | Bike | 4000 | 600 | |||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock Budget and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Your first month for $9.50 $19
50% off your first month when you join today.
Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.
Why this works
12,500 / 1,500 is 8.33. After 8 months you have saved 12,000, so the vacation needs a ninth month. ROUNDUP with 0 decimals always rounds up to the next whole number, so 8.33 becomes 9. A number that is already whole, like 9,000 / 750 = 12, stays as it is.
Common mistake: Rounding with ROUND. It rounds 8.33 down to 8 months, and the savings end up 500 short of the price.
The answer
- D2
=ROUNDUP(1B2/C2,20)
In plain words: Round 1the price in B2 divided by the savings per month in C2 up to 2a whole number of months.