# ROUND, ROUNDUP & ROUNDDOWN (Excel lesson 33 of 45)

> Formatting hides decimals; rounding removes them.

Source: https://spreadsheetpractice.com/learn/round-roundup-rounddown · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Analysis"
- **Time:** about 7 minutes, 3 graded exercises
- **Functions:** `ROUND`, `ROUNDUP`, `ROUNDDOWN`
- **Access:** Pro (the lesson text is free; the graded exercises need Pro)
- **Key formula:** `=ROUND(A2,2)`: To cents

## How it works

Number formatting changes how a value looks, not the value itself. Math still uses every decimal. `ROUND(x, 2)` actually changes the value to two places.

Negative digits round left of the decimal: `ROUND(x, -3)` rounds to the nearest thousand. `ROUNDUP` and `ROUNDDOWN` always go one way. Use ROUNDUP for "how many boxes do I need?"

## Syntax

| Formula | What it does |
|---|---|
| `=ROUND(A2,2)` | To cents |
| `=ROUNDUP(B2/C2,0)` | Always up to a whole number |
| `=ROUND(B2,-3)` | Nearest thousand |

## Watch out for

- Formatted values can appear to sum to $100.00 when the real total is $100.004. Round money before you total it.

## The exercises

Solve them in the live grid at [ROUND, ROUNDUP & ROUNDDOWN](https://spreadsheetpractice.com/learn/round-roundup-rounddown). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **Round to cents.** In B2, round each raw cost to 2 decimal places. Fill down to B6.
2. **Boxes needed.** In D2, calculate how many boxes each order needs. A partial box still counts as a box. Fill down to D6.
3. **Nearest thousand.** In C2, round each listing price to the nearest $1,000. Fill down to C6.

Previous: [Self-building summary tables](https://spreadsheetpractice.com/learn/summary-tables-unique-sumifs) · Next: [RANK, LARGE & SMALL](https://spreadsheetpractice.com/learn/rank-large-small)

---

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