ROUND in Google Sheets
Use ROUND to cut a number to a set number of decimal places — and ROUNDUP, ROUNDDOWN, and MROUND when you need to force the direction or snap to a step.
=ROUND(A2, 2)
Rounds A2 to 2 decimal places using standard rounding (0.5 rounds away from zero).
How it works
ROUND takes a number and the number of decimal places to keep. A positive places value rounds after the decimal point; 0 rounds to a whole number; a negative value rounds to tens, hundreds, and so on. Use ROUNDUP or ROUNDDOWN to force the direction regardless of the digit, and MROUND to snap to the nearest multiple (like the nearest 5 or 0.25).
Variations
Round up to a whole number
=ROUNDUP(A2, 0)
Always rounds away from zero — 2.1 becomes 3.
Round down (truncate decimals)
=ROUNDDOWN(A2, 2)
Always rounds toward zero — 2.999 becomes 2.99.
Round to the nearest 5
=MROUND(A2, 5)
Snaps to the nearest multiple of 5.
Round to the nearest hundred
=ROUND(A2, -2)
A negative places value rounds to the left of the decimal — 1234 becomes 1200.
Examples
| Scenario | Formula |
|---|---|
| Money to 2 decimals | =ROUND(A2, 2) |
| Whole units, always up | =ROUNDUP(A2, 0) |
| Nearest quarter | =MROUND(A2, 0.25) |
FAQ
What's the difference between ROUND and ROUNDUP?
ROUND follows the digit (0-4 down, 5-9 up), while ROUNDUP always rounds away from zero and ROUNDDOWN always toward zero, no matter the digit.
How do I round to the nearest 10 or 100?
Use a negative number of places: ROUND(A2, -1) for tens, ROUND(A2, -2) for hundreds.
How do I round to the nearest 0.5 or 5?
Use MROUND with that step, e.g. MROUND(A2, 0.5) or MROUND(A2, 5).