Excel + Google Sheets · ROUND
Round any number the right way
Rounds a result to the number of decimals you choose.
The formula
=ROUND(A2*1.2, 2)What each part means
A2*1.2Your calculation2Decimals to keep
Example
| A | B | |
|---|---|---|
| 1 | Price | With 20% tax |
| 2 | 10 | |
| 3 | 49.90 | |
| 4 | 3.35 | |
| 5 | 120 |
| A | B | |
|---|---|---|
| 1 | Price | With 20% tax |
| 2 | 10 | 12.00 |
| 3 | 49.90 | 59.88 |
| 4 | 3.35 | 4.02 |
| 5 | 120 | 144.00 |
Step by step
- Click cell B2.
- Type the formula:
=ROUND(A2*1.2, 2) - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)