How to round numbers in Excel
To round a number in Excel, use ROUND: =ROUND(A2,2) rounds to two decimals. The second argument is the number of digits, and it can be negative to round to tens, hundreds or thousands. ROUNDUP always rounds away from zero and ROUNDDOWN always rounds toward zero.
Rounding with a formula changes the stored value, while a number format only changes how the value looks. The difference matters when you add the numbers up, and the sections below show it.
1. Round to decimals
A positive digit count keeps that many decimals. 0 rounds to a whole number. The rule is the usual one: 5 or more rounds up, less than 5 rounds down.
Example: Two decimals
| A | B | |
|---|---|---|
| 1 | Value | Rounded |
| 2 | 3.1416 | 3.14 |
The third decimal is 1, so the number stays at 3.14.
2. Always round up or down
Use ROUNDUP when you must not fall short, for example the number of boxes needed to pack the items. Use ROUNDDOWN when you must not go over, for example the whole units a budget can buy.
Example: Round up to one decimal
| A | B | |
|---|---|---|
| 1 | Value | Rounded up |
| 2 | 3.1416 | 3.2 |
ROUNDUP moves 3.14159 up to the next tenth, 3.2, even though the next digit is only 4.
3. Round to tens, hundreds or thousands
A negative digit count counts to the left of the decimal point. -1 rounds to tens, -2 to hundreds and -3 to thousands. To round to a multiple that is not a power of ten, such as 0.05 or 25, use MROUND, CEILING or FLOOR.
Example: Round to hundreds
| A | B | |
|---|---|---|
| 1 | Value | Rounded |
| 2 | 1234.5678 | 1200 |
The tens digit is 3, so 1234.5678 rounds down to 1200.
4. Rounding versus formatting
If you only change the number of decimals with the Decrease Decimal button, the cell still holds the full value. Three cells of 0.4 formatted to show no decimals each show 0, but their sum shows 1, because the sum uses the real values. To make the sheet add what it shows, round inside the formula, for example =ROUND(A2,0). Rounding early can also lose accuracy, so round only the final result when you can.
Common mistakes
Rounding the display and trusting the total. The shown numbers do not add up to the shown total.
Fix: Round the values with ROUND if the shown numbers must add up, or accept the real total.
Rounding at every step. Rounding each part of a long calculation adds small errors.
Fix: Calculate with the full values and round the final answer.
Confusing negative digits. =ROUND(A2,-2) is not rounding to two decimals.
Fix: Positive digits are after the decimal point, negative digits are before it.
Frequently asked questions
How do I round to the nearest 5 or 0.05?
Use MROUND, for example =MROUND(A2,5) or =MROUND(A2,0.05). It rounds to the nearest multiple.
How do I remove the decimals without rounding?
Use ROUNDDOWN(A2,0) or INT for positive numbers. They cut the decimals instead of rounding.
Why does 2.5 round to 3 and not to 2?
Excel rounds halves away from zero, so 2.5 becomes 3 and -2.5 becomes -3.
Related functions
- ROUNDROUND rounds a number to a set number of digits; ROUNDUP and ROUNDDOWN always round away from or toward zero.
- SUMSUM adds up numbers, cells and whole ranges in one formula.
- AVERAGEAVERAGE returns the arithmetic mean of numbers or a range, skipping text and empty cells.
- MODMOD returns the remainder after division.
More on rounding numbers
The guide covers ROUND, ROUNDUP, ROUNDDOWN and the difference from formatting. This piece adds rounding money so the cents add up, rounding to a multiple, and the floating point surprise that makes a rounded total look wrong by a cent.
Round money so the cents add up
An invoice line is quantity times price, and a tax of 17% can give fractions of a cent. If each line shows two decimals but holds more, the total of the shown lines can differ by one cent from the total printed. Round each line, then add the rounded lines, so that what is shown is what is added.
=ROUND(B2*C2,2)
=ROUND(SUM(D2:D20)*0.17,2)Round to a multiple
Prices that end in 5 or 0, packs of 12 and time slots of 15 minutes all round to a multiple, not to a number of digits. MROUND rounds to the nearest multiple, CEILING rounds up to the next multiple and FLOOR rounds down. Choose CEILING when you must not under-order, as in how many boxes of 12 cover 50 items.
=ROUNDUP(50/12,0)Why a rounded total can be off by a cent
Computers store decimals in binary, so a number such as 0.1 is stored as a very close value, not exactly. Adding many of them can leave a tiny rest, like 0.30000000000000004, which a comparison then treats as different from 0.3. When you compare calculated amounts, round both sides to the same number of digits first.
Excel's display rounding hides this, so the cell looks fine until an equality test returns FALSE. For more on display and value, read [the rounding lesson](/learn/rounding) and [number formats](/learn/number-formats), then see the page for ROUND.