# How to round to the nearest 100 or 1000 in Excel

Use ROUND with a negative number of digits: =ROUND(A2,-2) rounds to the nearest 100, and -3 to the nearest 1000.

**Excel:** `=ROUND(A2,-2)` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B |
| --- | --- |
| Forecast | Nearest 100 |
| 12449 |  |
| 12450 |  |
| 8751.6 |  |
| 990 |  |
| 104349 |  |

Formula in B2, filled to B6: `=ROUND(A2,-2)`

Result: 12,400; 12,500; 8,800; 1,000; 104,300

## How it works

ROUND's second argument counts decimal places. Positive numbers round to the right of the decimal point; negative numbers round to the left: -1 to tens, -2 to hundreds, -3 to thousands. Halves round away from zero, so 12,450 becomes 12,500.

## Other ways

- `=MROUND(A2,100)`: MROUND rounds to any multiple, like 25 or 0.05, not only powers of ten.
- `=ROUNDUP(A2,-2)`: Always rounds up to the next hundred, for budgets and capacity. (Rounds up: 12,449 becomes 12,500.)

## Common mistakes

- Formatting a cell to show no decimals only changes how it looks; the full value is still used in sums. ROUND changes the value.
- Rounding each line and then summing can differ from rounding the total. Decide which one your report needs.

## Questions

**How do I round to the nearest 5?**

Use `=MROUND(A2,5)`, or `=ROUND(A2/5,0)*5`.

**How do I round to two decimal places?**

Use `=ROUND(A2,2)`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-29.

Source: https://spreadsheetpractice.com/formulas/round-to-the-nearest-hundred