ROUND Function
Rounds a number to a set number of decimal places.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Overview
ROUND changes the actual value to the decimals you choose, using normal rounding: 5 and above rounds up.
Formatting only changes how a number looks. ROUND changes what's stored, so totals of rounded figures add up exactly as shown.
Syntax
=ROUND(number, num_digits) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The number to round. |
| num_digits | Yes | Decimal places. 0 = whole number; negative values round to tens (−1), hundreds (−2) and so on. |
Examples
Example 1 — Rounding tax to the cent
Work out 13% tax, rounded to two decimals.
C2fx=ROUND(B2*13%, 2)
| A | B | C | |
|---|---|---|---|
| 1 | Item | Price | Tax |
| 2 | Widget | 19.99 | 2.6 |
| 3 | Gadget | 4.35 | 0.57 |
| 4 | Cable | 12.5 | 1.63 |
=ROUND(B2*13%, 2) Explain
Example 2 — Rounding to the nearest thousand
Use a negative num_digits for headline figures.
B2fx=ROUND(A2, -3)
| A | B | |
|---|---|---|
| 1 | Sales | Rounded |
| 2 | 125449 | 125000 |
| 3 | 98500 | 99000 |
| 4 | 7320 | 7000 |
=ROUND(A2, -3) Explain
Common mistakes
- Format vs. ROUND. A cell formatted to 2 decimals still holds every decimal. If totals look a cent out, round the values with ROUND.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.