➕ Math Function · beginner
ROUNDUP Function in Google Sheets
Rounds a number AWAY from zero to a specified number of decimal places.
Syntax
ROUNDUP(value, [places])Returns: value rounded away from zero.
Excel equivalent: ROUNDUP (identical)
Parameters
| Name | Required | Description |
|---|---|---|
| value | Required | Number to round. |
| places | Optional | Decimal places. Default 0. |
Examples
Always round up to next dollar
=ROUNDUP(A2, 0)1.01 → 2, 1.99 → 2.
Next hundred
=ROUNDUP(A2, -2)1247 → 1300.
Negatives
=ROUNDUP(-1.4, 0)Returns -2.
When to use an alternative
- ROUNDDOWN — Opposite direction.
- CEILING — Multiple of arbitrary unit.
- ROUND — Standard half-away-from-zero.
Common errors and how to fix them
Confused with CEILING
Cause: Different scopes.
Fix: ROUNDUP for decimal places, CEILING for multiples.
Related functions
ROUND
Rounds a number to a specified number of decimal places using standard half-away-from-zero rounding....
ROUNDDOWN
Rounds a number TOWARD zero to a specified number of decimal places....
ABS
Returns the absolute value of a number....
MOD
Returns the remainder of a division. Used for divisibility tests, cycles, and conditional formatting...
SUM
Adds up numbers in a range or list of values. The first function nearly every spreadsheet user learn...
Frequently Asked Questions
Negative behavior?
Away from zero — ROUNDUP(-1.4) = -2.
ROUNDUP vs CEILING?
ROUNDUP to decimal places; CEILING to arbitrary multiples like 0.5.