ROUNDUP()
Rounds a number away from zero, regardless of the digit that follows.
ROUNDUP(number, num_digits)ROUNDUP always rounds up in magnitude — 12.341 rounds up to 12.35 at 2 digits, the same as 12.349 would. This differs from ROUND, which would round 12.341 down to 12.34.
Common for scenarios where under-counting is a problem, like calculating how many boxes are needed to ship a quantity of items.
ROUNDUP is for quantities that cannot be fractional in the real world — cases to order, licences to buy, vehicles to book, staff to roster. The thing to be careful about is money: rounding every line up and then summing gives a total higher than rounding the sum, and on an invoice that difference is a visible discrepancy. Decide once whether the rounding happens per line or on the total, write it down, and apply it consistently. For rounding to a multiple rather than a decimal place, CEILING is the right function.
Arguments
- number
- The number to round.
- num_digits
- How many digits to round to. Negative rounds to the left of the decimal point.
Examples
=ROUNDUP(12.341, 2)Rounds up even though the next digit is small.
=ROUNDUP(22/5, 0)22/5 is 4.4 items — ROUNDUP ensures you order enough for all of them.
=ROUNDUP(B2/CaseSize, 0)*CaseSizeRounds an order quantity up to the next whole case — the standard pattern for pack sizes, pallet quantities and minimum order multiples.
Notes and gotchas
- ROUNDUP always moves away from zero. For a negative number that means more negative:
ROUNDUP(-2.1, 0)is -3. - If you want "always toward positive infinity" regardless of sign, use
CEILING.MATH, not ROUNDUP. - A negative
num_digitsrounds to the left of the decimal point:ROUNDUP(1234, -2)is 1300. Useful for rounding up to the nearest hundred. - Rounding for display only? Change the number format instead. ROUNDUP changes the stored value, and a column of rounded values will not add up to the rounded total.
Common errors
| You see | Because | Fix |
|---|---|---|
| #VALUE! | The number argument is text. | Check the source cell is numeric with ISNUMBER. |
ROUNDUP tricks, tips, and workbook hacks
ROUNDUP always rounds away from zero to the digit position you specify—even if the trailing fraction is 0.0001. That makes it essential for physical and operational constraints where a fractional unit requires a whole container: shipping boxes, headcount shifts, raw material rolls, or billed service hours.
Don't overlook negative and zero values for num_digits: 0 rounds up to the next whole integer, and -2 or -3 rounds up to the next hundred or thousand.
Quick ROUNDUP checks before trusting the result
- Use num_digits = 0 whenever fractional units are impossible in the physical world (pallets, trucks, seats, licenses).
- Calculate Calendar Quarter (1, 2, 3, 4) from any date with =ROUNDUP(MONTH(A2)/3, 0).
- Remember that ROUNDUP rounds away from zero, so ROUNDUP(-4.1, 0) becomes -5.
| ROUNDUP pattern | ROUNDUP formula | Best use | Watch out |
|---|---|---|---|
| Cartons or pallets required for an order quantity | =ROUNDUP(B2/C2,0) | Ordering 125 units (B2) when each master carton holds 24 units (C2) → requires 6 cartons. | Plain ROUND(125/24, 0) would return 5 cartons (120 units), leaving the shipment 5 units short! |
| Convert any date into its calendar quarter (1–4) | ="Q"&ROUNDUP(MONTH(A2)/3,0) | Tagging transaction dates into Q1, Q2, Q3, or Q4 without a 12-row lookup table. | Dividing months 1–12 by 3 and rounding up maps 1..3→1, 4..6→2, 7..9→3, 10..12→4. |
| Round a project contingency budget up to the next $1,000 | =ROUNDUP(B2*1.15,-3) | Adding a 15% buffer and snapping up to the next whole thousand dollars. | Negative num_digits (-1, -2, -3) round to the left of the decimal point (10s, 100s, 1000s). |
| ROUNDUP mistake | What happens in ROUNDUP | Fix |
|---|---|---|
| Floating-point dust causing exact integers to jump up by 1 | A calculated division that looks like 5.000000000000001 in binary floating-point gets pushed to 6 by ROUNDUP(..., 0). | Wrap the inner division in ROUND(val, 9) first if floating-point subtraction is involved: =ROUNDUP(ROUND(B2/C2, 9), 0). |
ROUNDUP practice drills
- Test =ROUNDUP(MONTH(A2)/3, 0) across all 12 months of the year to verify the Quarter mapping.



