Math & aggregation
How to Round Numbers in Excel (ROUND, ROUNDUP, MROUND)
Rounding in Excel changes the actual value, not just how it looks. ROUND rounds to a set number of decimal places, ROUNDUP and ROUNDDOWN always push in one direction, and MROUND snaps to the nearest multiple, such as the nearest 5 or 0.05.
This guide shows the syntax for each function, how the digit argument works (including negative digits to round to tens, hundreds, or thousands), and how to pick the right one for currency, pricing, and reporting.
ROUND syntax
=ROUND(number, num_digits) | Argument | Required | What it does |
|---|---|---|
number | Required | The value or cell reference you want to round. |
num_digits | Required | How many decimal places to keep. Use 0 for a whole number, 2 for cents, or a negative number to round left of the decimal (-3 = nearest thousand). |
multiple (MROUND only) | Optional | For MROUND, the multiple to snap to instead of num_digits, e.g. 5 or 0.05. |
Note: ROUNDUP and ROUNDDOWN take the same two arguments as ROUND. MROUND rounds to the nearest multiple. All work the same in Google Sheets.
Examples
Real, copy-paste-ready formulas.
1. Round to 2 decimal places
=ROUND(A2, 2) Keeps two decimals using standard rounding, so 3.14159 becomes 3.14 and 2.675 becomes 2.68. Ideal for currency where you want true rounded values, not just a display format.
2. Always round up to a whole number
=ROUNDUP(A2, 0) ROUNDUP forces the value away from zero, so 4.1 becomes 5. With num_digits 0 it rounds to whole numbers; useful for units, batches, or rounding up an estimate.
3. Round down to a whole number
=ROUNDDOWN(A2, 0) ROUNDDOWN always pushes toward zero, so 4.9 becomes 4. It is the safe choice when you must not overstate a figure.
4. Round to the nearest 5
=MROUND(A2, 5) MROUND snaps to the closest multiple, so 23 becomes 25 and 22 becomes 20. Use 0.05 for prices ending in 5 cents, or 0.5 for half steps.
How to write ROUND step by step
- 1
Click the result cell and type =ROUND( (or ROUNDUP, ROUNDDOWN, MROUND).
- 2
Click the cell that holds the number you want to round, then type a comma.
- 3
Type the number of decimal places to keep: 0 for whole numbers, 2 for cents, -3 to round to the nearest thousand.
- 4
For MROUND, type the multiple to snap to instead (5, 0.05, 0.25), then a comma is not needed.
- 5
Close the bracket ) and press Enter.
- 6
Copy the formula down the column to round a whole list at once.
Common errors and fixes
| Error | Why it happens | How to fix it |
|---|---|---|
#NUM! | In MROUND, the number and the multiple have different signs (e.g. a positive number with a negative multiple). | Use a multiple with the same sign as the number, or take the absolute value first. |
#VALUE! | The number argument is text rather than a real number. | Convert text to a number (VALUE() or multiply by 1) before rounding. |
Value did not round | You changed the cell format (Decrease Decimal) instead of using a formula, so the stored value is still long. | Use ROUND in a formula to change the actual value; cell formatting only changes the display. |
Totals are off by a cent | Displayed (formatted) values were rounded but the underlying numbers were not, so sums differ. | Round each value with ROUND before summing, so the stored numbers match what you see. |
Frequently asked questions
What is the difference between ROUND and ROUNDUP?
ROUND uses normal rounding (5 and above rounds up, below 5 rounds down). ROUNDUP always rounds away from zero, so 4.1 becomes 5. ROUNDDOWN always rounds toward zero.
How do I round to the nearest 10, 100, or 1000?
Use a negative num_digits: =ROUND(A2, -1) rounds to the nearest 10, -2 to the nearest 100, and -3 to the nearest 1000.
Does formatting a cell round the number?
No. Decrease Decimal only changes the display; the full value is still stored and used in calculations. Use the ROUND function to change the actual value.
How do I round to the nearest 5 cents?
Use MROUND with a 0.05 multiple: =MROUND(A2, 0.05) snaps a price to the nearest five cents, so 1.23 becomes 1.25.