ROUNDUP
Round a number up, away from zero, to a given number of digits — whatever the next digit is.
Syntax
ROUNDUP(number, num_digits)| Argument | Required | Description |
|---|---|---|
number | Required | The number to round. |
num_digits | Required | Decimal places to keep. 0 rounds to a whole number; negative values round to tens, hundreds and so on. |
Examples
Every example below was executed against VisiGrid engine 0.54.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=ROUNDUP(3.21,1) | 3.30 | Shown to two decimal places; the value is 3.3. |
=ROUNDUP(-3.21,1) | -3.30 | Away from zero, so a negative number becomes more negative. |
=ROUNDUP(A2/B2,0) | 21 | 250 guests at tables of 12 need 21 tables, not 20.8. |
=ROUNDUP(1234,-2) | 1300 | |
=ROUNDUP(1.1,2) | 1.10 | A value that already has two decimals is left alone. |
Counting whole things
ROUNDUP is for quantities that cannot be fractional and must cover the need:
boxes to ship, buses to book, sheets of plywood, hours to bill in whole units.
Anything short of a whole one still needs a whole one.
=ROUNDUP(250/12,0) → 21Away from zero, not towards positive
For negative numbers, “up” means further from zero: ROUNDUP(-3.21,1) is
-3.3, not -3.2. To round towards positive infinity instead, or to a multiple
such as the nearest 0.05, use CEILING.
Excel compatibility
Matches Excel.