Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
ROUNDUP and ROUNDDOWN. ROUND goes to the nearest value. ROUNDUP always moves away from zero and ROUNDDOWN always towards it, whatever the next digit is. The second part is the number of decimals: 2 for cents, 1 for tens of cents, 0 for whole numbers.
=ROUNDUP(A2/12,0) boxes needed when a box holds 12
From January Brightline raises list prices on cleaning and desk products. Pricing rounds every new price up to the next 10 cents and every promo price down to the cent, so a promo never costs more than advertised.
In C2:C9, raise each list price by the % in G1 and round UP to 1 decimal. In D2:D9, take the promo discount in G2 off the new price and round DOWN to 2 decimals. Point at G1 and G2 rather than typing the rates.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product | List price | New price | Promo price | Price rise | 4% | ||
| 2 | All-Purpose Cleaner 5L | $14.00 | Promo discount | 15% | ||||
| 3 | Hand Soap Refill 5L | $17.50 | ||||||
| 4 | Paper Towels (24) | $25.00 | ||||||
| 5 | Trash Bags (200) | $15.00 | ||||||
| 6 | Disinfectant Wipes (12) | $21.00 | ||||||
| 7 | Microfiber Cloths (50) | $23.50 | ||||||
| 8 | Stapler Heavy Duty | $22.00 | ||||||
| 9 | Desk Organizer | $19.00 | ||||||
| 10 | ||||||||
| 11 | ||||||||
| 12 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe