Google Sheets ROUND / ROUNDUP / ROUNDDOWN Functions — Syntax, Examples & Tips

What They Do

ROUND rounds a number to a specified number of decimal places using standard rounding rules (5 and above rounds up). ROUNDUP always rounds away from zero, regardless of the digit. ROUNDDOWN always rounds toward zero, effectively truncating. These three functions give you precise control over how numbers are displayed and calculated — critical for financial reports, pricing, and scientific data.

Syntax

=ROUND(value, [places])
=ROUNDUP(value, [places])
=ROUNDDOWN(value, [places])

Basic Examples

Round to two decimal places

Result in B2: 19.88

Standard rounding: the third decimal (6) is 5 or more, so the second decimal rounds up.

Always round up for pricing

Results:

ROUNDUP pushes every non-zero trailing digit upward, even if it is just 1.

Drop decimals without rounding

Result in B2: 87

ROUNDDOWN simply chops off the decimal portion, ignoring the .96 entirely.

Advanced Examples

Round to the nearest thousand

Use a negative places value to round to the left of the decimal point:

=ROUND(148250, -3)

Result: 148000

The -3 tells ROUND to zero out the last three digits and round based on the hundreds place. This is useful for executive summaries or dashboards where precise numbers are not needed.

Similarly:

• =ROUNDUP(148250, -3) returns 149000
• =ROUNDDOWN(148250, -3) returns 148000

Handle currency calculations without floating-point errors

Multiplying prices and quantities sometimes produces results like 29.9999999999. This causes visible rounding artifacts in reports:

=ROUND(B2 * C2, 2)

Wrapping your arithmetic in ROUND with 2 decimal places prevents those stray digits from showing up in invoices and totals. For tax calculations where you must always round in the customer's favor, use ROUNDDOWN:

=ROUNDDOWN(subtotal * tax_rate, 2)

Common Mistakes

• Confusing ROUND with formatting. Changing a cell's decimal display (Format > Number) only affects how the number looks — the full precision is still there and used in calculations. ROUND actually changes the value. If downstream formulas depend on rounded numbers, use the function rather than formatting.
• Forgetting that ROUNDUP rounds away from zero for negative numbers. =ROUNDUP(-3.2, 0) returns -4, not -3. It moves away from zero in both directions. If you want to always round toward a higher value (not just away from zero), use CEILING instead.
• Omitting the places argument when you need decimals. =ROUND(3.456) returns 3 because places defaults to 0. Always specify the number of decimal places you need.

SheetAI Tip

Don't want to memorize this syntax? With SheetAI, just type what you need in plain English and the formula is generated for you. Install SheetAI to try it free.