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.
It comes up in this mock test: Excel test (iMocha format)
Your first month for $9.50 $19
50% off your first month when you join today.
Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.
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.