Exercises / Foundations · 11 of 12
Price with VAT, to the cent
ROUND(number, digits) rounds to a number of decimals: ROUND(12.3456, 2) is 12.35. Formatting only hides decimals; ROUND changes the value, which matters when you add the results up.
ROUND(number, num_digits)Syntax
Rounds to a number of digits.
Your taskIn C2, work out the price including VAT: the net price in B2 times (1 + the VAT rate in F1), rounded to 2 decimals with ROUND. It will be copied down to C6.
I'll check your formula on this sheet and on changed versions of it, so it has to work in general. Stuck? Ask for a hint, one step at a time.
Answer cell
Type in a cell, or double-click it to edit
| Row | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Item | Net price | With VAT | VAT rate | 20% | ||
| 2 | Headphones | 41.658 | |||||
| 3 | Keyboard | 57.325 | |||||
| 4 | Mouse | 18.749 | |||||
| 5 | Webcam | 63.912 | |||||
| 6 | USB hub | 22.083 | |||||
| 7 | |||||||
| 8 | |||||||
| 9 |