Round a price to two decimals
Step 1 of 3
ROUND rounds a number to the number of decimals you choose: =ROUND(number, 2) keeps two decimals.
Click Continue when you're ready.
Already know it? Type the formula straight into C2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Item | Price | With 25% VAT | |||
| 2 | Headphones | 79.99 | ||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
79.99 × 1.25 is 99.9875. ROUND(number, 2) keeps two decimals and rounds half up, giving 99.99. Formatting a cell to show two decimals only changes what you see; ROUND changes the value.
Common mistake: Formatting the cell to show two decimals instead of rounding. The cell still holds 99.9875, and totals use the hidden decimals.
The answer
- C2
=ROUND(1B2*1.25,22)
In plain words: Round 1the price in B2 plus 25% VAT to 22 decimal places.
+10 points