Syntax
=ROUND(number, num_digits)| Argument | What it means |
|---|---|
number | The number to round. |
num_digits | How many decimal places to keep. 0 gives a whole number. A negative number rounds to tens, hundreds and so on. |
Examples with results
Every result below is calculated by the practice engine on the sample data shown, not typed in by hand.
Examples that need no data
=ROUND(2.345,2)Round to 2 decimal places
=ROUND(1234.5,-2)Round to the nearest hundred
Price list (fictional)
| Row | A | B | C |
|---|---|---|---|
| 1 | Code | Product | Price |
| 2 | P-101 | Desk lamp | 24.9 |
| 3 | P-102 | Notebook | 3.5 |
| 4 | P-103 | Mouse | 15 |
| 5 | P-104 | Keyboard | 32 |
| 6 | P-105 | Monitor stand | 21 |
=ROUND(AVERAGE(C2:C6),2)Round an average price
Try it yourself
Change the formula or switch to other sample data.
Press Calculate to see the result.
The practice box runs in your browser with BDK’s own calculator, which covers about 60 common functions. Cell references work as in Excel (B2, B2:B9). Your formulas are not saved or sent anywhere. For anything unusual, check the result in Excel itself.
How people use ROUND at work
- Finance and accounting
Round a calculated amount to 2 decimals before you add it to an invoice.
Data: Office supplies sales (fictional)=ROUND(B2*C2*1.05,2) - Personal budgeting
Show a weekly allowance as a whole number.
Data: Monthly budget (fictional)=ROUND(B3/4,0)
Common mistakes and tips
- Formatting a cell to show 2 decimals does not change the value underneath. ROUND really changes it, which matters when totals must match.
Works in
All versions of Excel, and Google Sheets.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.