How to Use ROUNDUP and ROUNDDOWN in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: =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
1Value
212.341
31275
=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

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.

Hint: places is 2.

Exercise 2: Down to the hundred

Write a formula that rounds the number in A3 down to the hundred.

Hint: use a negative number of places.

What to learn next

Syntax and rules in this guide were checked against Google's ROUNDUP/ROUNDDOWN help page. See all guides.