ROUND takes a number and rounds it to a specified number of digits. It returns a single rounded number, using standard half-up rounding for positive numbers.
=ROUND(number, num_digits)What does ROUND do?
The ROUND function is one of Excel's simplest and most useful math functions. You give it a number and tell it how many digits to keep, and it returns a rounded version of that number. It is part of the Math & Trigonometry category and works in every version of Excel.
Rounding matters because raw calculations often produce long decimals that look messy or cause tiny mismatches. Prices, tax totals, averages, and unit conversions all benefit from being rounded to sensible precision. ROUND also makes reports easier to read and helps avoid confusing fractions of a cent in financial summaries.
A typical situation: you calculate an average order value of 47.8367 and need to show 47.84 in a report. Instead of changing the cell format (which only hides digits), you use =ROUND(B2, 2) so the stored value itself is rounded. That keeps later calculations consistent with what people see.
When to use ROUND
- Rounding prices, totals, and tax amounts to two decimal places
- Cleaning up averages and percentages for reports and dashboards
- Rounding measurements or unit conversions to a practical precision
- Preparing data for invoices, payslips, or financial statements
- Making charts and summaries easier to read by trimming decimals
- Standardising imported data that has inconsistent decimal places
ROUND syntax
=ROUND(number, num_digits)| Argument | Required? | What to enter |
|---|---|---|
number | Required | The value you want to round. It can be a number, a cell reference, or a calculation. Example: B2 or 47.8367. |
num_digits | Required | How many digits to round to. Positive rounds to decimal places (2 means hundredths), zero rounds to a whole number, and negative rounds to tens, hundreds, and so on. Example: 2 or -1. |
What it returns: A number rounded to the requested number of digits. The result is a numeric value, not text, so it can be used in further calculations.
ROUND examples
1 Round a price to two decimal places
This is the most common use. Cell B2 holds a unit price with four decimals. The formula =ROUND(B2, 2) keeps two decimal places and rounds the third decimal up or down using standard rounding. The result is 12.35 because the third decimal is 6, which rounds the 34 up to 35.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Raw Price | |||
| 2 | Notebook | 12.3456 | 12.35 | ||
| 3 | Pen | 3.9871 | |||
| 4 | Folder | 7.5 | |||
| 5 | Stapler | 15.999 | |||
| 6 |
2 Round an average to one decimal place
Averages often produce long decimals. Here B2 contains an average score of 83.6667. The formula =ROUND(B2, 1) rounds to one decimal place. The second decimal is 6, so the first decimal rounds up from 6 to 7, giving 83.7.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Student | Average Score | |||
| 2 | Ava | 83.6667 | 83.7 | ||
| 3 | Ben | 72.25 | |||
| 4 | Chloe | 91.4444 | |||
| 5 | Daniel | 65.5 | |||
| 6 |
3 Round to the nearest whole number
When you need whole units, use zero as the second argument. B2 holds 47.8367. The formula =ROUND(B2, 0) rounds to the nearest integer. Since the first decimal is 8, the number rounds up to 48.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product | Units Sold (Avg) | |||
| 2 | Widget | 47.8367 | 48 | ||
| 3 | Gadget | 12.2 | |||
| 4 | Gizmo | 99.5 | |||
| 5 | Doohickey | 3.49 | |||
| 6 |
4 Round to the nearest ten
Negative num_digits round to the left of the decimal point. B2 contains 1,247. The formula =ROUND(B2, -1) rounds to the nearest ten. The ones digit is 7, so 1,247 rounds up to 1,250.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Sales | |||
| 2 | North | 1247 | 1250 | ||
| 3 | South | 982 | |||
| 4 | East | 1505 | |||
| 5 | West | 733 | |||
| 6 |
5 Round a calculated total for an invoice
This example rounds a line total that includes a small discount. B2 is the quantity, C2 is the unit price, and the formula calculates B2*C2 first, then rounds to two decimals. 3 times 19.995 is 59.985, which rounds to 59.99 because the third decimal is 5.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Item | Qty | Unit Price | |||
| 2 | Chair | 3 | 19.995 | 59.99 | ||
| 3 | Desk | 2 | 149.5 | |||
| 4 | Lamp | 5 | 12.345 | |||
| 5 |
Common ROUND errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | The number argument is text that Excel cannot convert, such as a word or a date stored as text. | Make sure the cell contains a real number. Use VALUE or clean the data, or reference a numeric cell. |
| #NAME? | The function name is misspelled, for example ROUNDD or ROUND( with a missing parenthesis. | Type =ROUND( and let Excel suggest the function, or check the spelling and parentheses. |
| #NUM! | The num_digits argument is extremely large or invalid in a way Excel cannot handle, or the number is outside Excel's limits. | Use a sensible num_digits value, usually between -15 and 15, and check that the number is within Excel's numeric range. |
| Wrong rounding direction | ROUND uses half-up rounding, so 2.5 becomes 3, but some people expect banker's rounding or always-down behaviour. | If you need different behaviour, use ROUNDUP, ROUNDDOWN, or MROUND depending on the rule you need. |
| Formula shows a date or strange number | The cell is formatted as a date or currency and the rounded number is being displayed in that format. | Change the cell format to General or Number to see the rounded value as expected. |
Tips for using ROUND
- ROUND changes the stored value; number formatting only changes what you see. Use ROUND when later calculations must match the displayed value.
- Use positive num_digits for decimal places, zero for whole numbers, and negative for tens, hundreds, or thousands.
- Remember that ROUND uses half-up rounding: 2.5 becomes 3 and -2.5 becomes -3.
- To round a calculation, put the whole expression inside ROUND, for example
=ROUND(B2*C2, 2). - Avoid rounding too early in a chain of calculations; round at the final step to reduce accumulated error.
- If you need to always round up or down, use ROUNDUP or ROUNDDOWN instead of ROUND.
Frequently asked questions
What is the difference between ROUND and number formatting?
Formatting only changes how a number looks, while ROUND changes the actual stored value. If you format 12.3456 to two decimals it still calculates as 12.3456, but =ROUND(12.3456, 2) stores 12.35.
How do I round to the nearest thousand?
Use a negative num_digits. For example, =ROUND(12345, -3) returns 12000 because it rounds to the nearest thousand.
Does ROUND work with negative numbers?
Yes. ROUND rounds negative numbers away from zero at the halfway point, so =ROUND(-2.5, 0) returns -3.
Can I use ROUND inside another formula?
Yes. ROUND is often nested inside SUM, AVERAGE, or arithmetic expressions, for example =ROUND(AVERAGE(B2:B10), 1).
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. ROUND reference