About this lesson
Rounding properly in Google Sheets
In Google Sheets, =ROUND(A1,2) rounds to 2 decimal places and changes the value, not just how it looks. ROUNDUP always rounds away from zero (whole cartons to order), ROUNDDOWN and INT round down (whole units to send), and =MROUND(A1,0.05) rounds to the nearest multiple, such as 5 cents.
Using Excel? Do this lesson in Excel.
=ROUND(B2*(1-$B$8),2)What you'll practise
Price Kookaburra Retail's Christmas catalogue: round promo prices to the cent and to 5c, order whole cartons with ROUNDUP and split stock between stores with ROUNDDOWN.
4 steps · 40 points · the cells outlined in gold below
- ROUND
- MROUND
- ROUNDUP
- ROUNDDOWN
- INT
- display vs value
The data
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Product | Shelf price | Promo price | Forecast units | Cartons to order | Units per store |
| 2 | Fruit mince tarts 12pk | $6.49 | 4181 | |||
| 3 | Christmas pudding 900g | $12.99 | 2942 | |||
| 4 | Shortbread tin 500g | $9.79 | 3519 | |||
| 5 | Panettone 750g | $14.49 | 1874 | |||
| 6 | Gingerbread house kit | $11.49 | 2656 | |||
| 7 | ||||||
| 8 | Promo discount | 15% | ||||
| 9 | Units per carton | 12 | ||||
| 10 | Stores in the promo | 38 |