ROUND
Control how many decimal places a result keeps
0 of 3 done · Lesson 12 of 18
Understand
A buyer needs tax-inclusive prices that stop at cents. The source prices carry extra decimals, so ROUND turns each calculation into a usable currency value.
=ROUND(what to round, decimal places to keep)
A worked example
=ROUND(B3*C3, 2)
what to rounddecimal places to keep
B3 is 184.275 and C3 is 1.2, so this returns 221.13
The sheet you are working with
| Row number | A | B | C | D |
|---|---|---|---|---|
| 1 | Item | Net price | Tax factor | Units |
| 2 | Monitor arm | 63.633 | 1.2 | 4 |
| 3 | Dock | 184.275 | 1.2 | 3 |
| 4 | Laptop | 1288.74 | 1.2 | 2 |
| 5 | Headset | 92.496 | 1.2 | 7 |
| 6 | Keyboard | 117.555 | 1.2 | 5 |