# ROUND function in Excel

> ROUND rounds a number to the number of digits you choose.

Source: https://spreadsheetpractice.com/functions/round · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** ROUND rounds a number to the number of digits you choose.
- **Syntax:** `=ROUND(number, num_digits)`
- **Most common use:** `=ROUND(B2,2)` returns 23.46 (To the cent: 23.4567 becomes 23.46)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The rounded number. Unlike cell formatting, the stored value changes.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

ROUND rounds a number to the number of digits you choose. Positive digits round to the right of the decimal point (2 for cents), 0 rounds to a whole number, and negative digits round to the left (-3 for the nearest thousand). Halves round away from zero.

## Syntax

`=ROUND(number, num_digits)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The number or calculation to round. |
| `num_digits` | Required | How many digits to keep: 2 for cents, 0 for whole numbers, -2 for the nearest hundred. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=ROUND(B2,2)` | 23.46 | To the cent: 23.4567 becomes 23.46 |
| D3 | `=ROUND(B3,0)` | 1288 | A half rounds away from zero, so 1287.5 becomes 1288 |
| D4 | `=ROUND(B4,-2)` | 200 | Negative digits round to the left: the nearest hundred |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Item | Amount |  | Rounded |
| 2 | Price with tax | 23.4567 |  | 23.46 |
| 3 | Units shipped | 1287.5 |  | 1288 |
| 4 | Budget estimate | 249.95 |  | 200 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Totals are off by a cent | Formatting a cell to two decimals only changes what you see; SUM still adds the hidden decimals. Round each amount with ROUND(…,2) before totaling. |
| Expected 2.5 to become 2 | Excel rounds halves away from zero (2.5 to 3, -2.5 to -3). It doesn't use the banker's rounding found in some programming languages. |
| Excel says too few arguments | num_digits is required. Use 0 to round to a whole number. |

## Tips

- Round at the step where the number becomes money, such as each invoice line, so totals match what customers see.
- ROUND(A2,-3) rounds to the nearest thousand, which is handy for summary reports.

## Related functions

- [ROUNDUP](https://spreadsheetpractice.com/functions/roundup): ROUNDUP always rounds away from zero, whatever the next digit is.
- [ROUNDDOWN](https://spreadsheetpractice.com/functions/rounddown): ROUNDDOWN always rounds toward zero, dropping the extra digits whatever they are.
- [MROUND](https://spreadsheetpractice.com/functions/mround): MROUND rounds a number to the nearest multiple of another number.
- [INT](https://spreadsheetpractice.com/functions/int): INT rounds a number down to the nearest whole number.
- [TRUNC](https://spreadsheetpractice.com/functions/trunc): TRUNC cuts a number off at a set number of decimals without rounding.
- Comparison: [ROUND vs ROUNDUP vs ROUNDDOWN](https://spreadsheetpractice.com/functions/compare/round-vs-roundup-vs-rounddown)

## Questions

### How do I round to the nearest 5 in Excel?

Use =MROUND(A2,5). With ROUND alone, divide, round and multiply back: =ROUND(A2/5,0)*5.

### How do I round to 2 decimal places in Excel?

Use =ROUND(A2,2). Changing the number format only hides the extra decimals; it doesn't round the value.

### How do I round to the nearest thousand?

Use a negative num_digits: =ROUND(A2,-3) turns 48,650 into 49,000.

## Practice

A graded ROUND exercise ("Round to cents") is on [the ROUND page](https://spreadsheetpractice.com/functions/round). It is checked instantly, then re-checked on changed data.

Lessons that use ROUND:

- [Lesson 33: ROUND, ROUNDUP & ROUNDDOWN](https://spreadsheetpractice.com/learn/round-roundup-rounddown) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
