For IndividualsFor Analysts & FinanceFor Students & LearnersFor Teams & Automation
MENU
=FUNCTIONS

ROUNDUP()

Math & Trig

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)
→12.35

Rounds up even though the next digit is small.

=ROUNDUP(22/5, 0)
→5

22/5 is 4.4 items — ROUNDUP ensures you order enough for all of them.

=ROUNDUP(B2/CaseSize, 0)*CaseSize
→144

Rounds 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_digits rounds 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

What goes wrong with ROUNDUP, and why
You seeBecauseFix
#VALUE!The number argument is text.Check the source cell is numeric with ISNUMBER.
Tips / Tricks / Hacks

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 tricks and formula patterns
ROUNDUP patternROUNDUP formulaBest useWatch 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).
Common ROUNDUP mistakes and how to fix them
ROUNDUP mistakeWhat happens in ROUNDUPFix
Floating-point dust causing exact integers to jump up by 1A 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

  1. Test =ROUNDUP(MONTH(A2)/3, 0) across all 12 months of the year to verify the Quarter mapping.

Related functions