How to Use ROUNDUP and ROUNDDOWN in Google Sheets
=ROUNDUP(value, [places]) always rounds up and =ROUNDDOWN(value, [places]) always rounds down. They work like ROUND, but the direction never depends on the next digit.
When ROUND is not enough
ROUND follows the usual rule: it rounds up only when the next digit is 5 or more. Sometimes the rule must be one-sided. Packaging needs whole boxes, so you always round up. A discount should never overshoot, so you always round down. That is what ROUNDUP and ROUNDDOWN are for.
Syntax
=ROUNDUP(value, [places])
=ROUNDDOWN(value, [places])
Per Google's help pages, both take the number to round and an optional number of decimal places. The default is 0. A negative value rounds at digits to the left of the decimal point. ROUNDUP works like ROUND but always rounds up, and ROUNDDOWN works like ROUND but always rounds down.
A step-by-step example
Cell A2 holds 12.341 and cell A3 holds 1275.
| A | |
|---|---|
| 1 | Value |
| 2 | 12.341 |
| 3 | 1275 |
=ROUNDUP(A2, 2)
This returns 12.35. Here is why: the number is cut to two decimals, and because there is something left over after 12.34, the last kept digit goes up. A plain ROUND would give 12.34, since the next digit is 1.
=ROUNDDOWN(A3, -2)
This returns 1200. The negative places value works on the hundreds position, and ROUNDDOWN always goes down, so 1275 becomes 1200. =ROUNDUP(A3, -2) would return 1300.
Common mistakes
- Expecting ROUND behavior. These two ignore the "5 or more" rule completely.
- Mixing up the sign of places. Positive places work right of the decimal point, negative places work left of it.
- Rounding for display only. Number formatting changes how a value looks, not what it is.
Try it yourself
Use the numbers above (A2 and A3). Type your formula into the box, starting with =, then press Check.
Exercise 1: Always up
Write a formula that rounds the number in A2 up to two decimal places.
Exercise 2: Down to the hundred
Write a formula that rounds the number in A3 down to the hundred.
What to learn next
- ROUND: round numbers to any number of places.
- RANK: rank a value within a list.
- SUMPRODUCT: multiply two ranges and add the results.
Syntax and rules in this guide were checked against Google's ROUNDUP/ROUNDDOWN help page. See all guides.