ROUND to the nearest thousand
A negative number of digits rounds to the left of the decimal point.
Task:
The board pack shows revenue in round thousands. Round each region's revenue in column B to the nearest thousand in column C.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of ROUND
0/4The same formula in the other shapes it takes at work.
- ROUND Function
Round numbers to specific decimal places.
CoreBeginner - ROUND to the nearest thousand
A negative number of digits rounds to the left of the decimal point.
Beginner - ROUNDUP and ROUNDDOWN: rounding in one direction
When the rule is "always up" or "always down", ROUND is the wrong tool.
Intermediate - ROUND inside a calculation
Round each line where it is calculated, so the invoice adds up to the penny.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Region | Revenue | Board figure |
| 2 | North | 248613 | |
| 3 | South | 191480 | |
| 4 | East | 327500 | |
| 5 | West | 84299 |
What this exercise teachesMay contain the answer
Formatting a cell to show thousands only changes what you see; the full figure still flows into every sum. ROUND with -3 changes the value itself, which is what you want when a board figure must add up to the board total. 327,500 sits exactly halfway and rounds up, as Excel always does.