Round to the nearest hundred
PremiumIn C2, use ROUND to round the visitor count in B2 to the nearest hundred. A negative number of decimals rounds to the left of the decimal point.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event | Visitors | Rounded | |||
| 2 | Copenhagen | 18749 | ||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock ROUND, ROUNDUP and ROUNDDOWN and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:Relative and absolute referencesPercentages
It comes up in this mock test: Excel test (iMocha format)
Need help?
Why this works
ROUND counts decimals from the decimal point: 2 means hundredths, 0 means whole numbers, -1 tens and -2 hundreds. 18,749 is closer to 18,700 than to 18,800.
Common mistake: Using 2 instead of -2. Positive decimals round to the right of the decimal point; hundreds need a negative number.
The answer
- C2
=ROUND(1B2,2-2)
In plain words: Round 1the visitor count in B2 to 2the nearest hundred.