What it does
ROUND rounds 5 and above up and the rest down; ROUNDUP moves to the next value however small the dropped part is. =ROUNDUP(12.01,0) gives 13 and =ROUNDUP(3.14159,2) gives 3.15.
The second argument is the number of digits: 0 rounds to a whole number, 1 and 2 to decimals, and negative numbers round to the left of the decimal point. =ROUNDUP(1234,-1) is 1240 and with -2 it is 1300. That is how you take a price up to the next ten.
With negative numbers the direction is away from zero: =ROUNDUP(-2.3,0) gives -3. To round up to a multiple (such as boxes of 12) use CEILING.MATH; to always round down use ROUNDDOWN.
Syntax
=ROUNDUP(number, num_digits)=YUKARIYUVARLA(sayı; basamak)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
number | Required | The number to round, or a formula that produces it, e.g. B2/C2. |
num_digits | Required | The number of digits to keep after the decimal point. 0 rounds to a whole number; negative values round to the tens (-1) and hundreds (-2). |
Examples
1Top an order quantity up to whole boxes
The quantity is divided by the box size and the result is rounded up to a whole number, so a few leftover items still count as one more box.
=ROUNDUP(B2/C2,0)| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Order Qty | Box Size | Boxes |
| 2 | Notebook | 250 | 24 | 11 |
| 3 | Pen | 1200 | 100 | 12 |
| 4 | Binder | 87 | 12 | 8 |
| 5 | Eraser | 500 | 48 | 11 |
- D2 (filled down to D5)
=ROUNDUP(B2/C2,0)
250 notebooks do not fit into 10 boxes of 24; the formula gives 11 boxes. The pen order fills exactly 12 boxes, so nothing is rounded: 12.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Take the label price up to the next ten
Column D adds the margin to the cost. Column E rounds that price up to the next ten with num_digits -1; a price that is already a multiple of 10 stays the same.
=B2*(1+C2)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Cost | Margin | Calculated Price | Label Price |
| 2 | Flask | 412.40 | 35% | 556.74 | 560 |
| 3 | Mug | 86.90 | 40% | 121.66 | 130 |
| 4 | Bottle | 233.00 | 30% | 302.90 | 310 |
| 5 | Tea Set | 1,189.50 | 25% | 1,486.88 | 1,490 |
- D2 (filled down to D5)
=B2*(1+C2) - E2 (filled down to E5)
=ROUNDUP(D2,-1)
The flask's calculated price of 556.74 becomes 560 on the label. The mug works out at 121.66 and still goes up to the next ten: 130.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Result larger than expected
Cause: The number is really something like 12.0000001; even a tiny leftover from earlier calculations was rounded up to the next number.
Fix: Round it to a few decimals with ROUND first:
=ROUNDUP(ROUND(B2/C2,6),0).- #VALUE!
Cause: number or num_digits is text that cannot be read as a number.
Fix: Make sure the cells really hold numbers; convert numbers stored as text.
Good to know
- Hiding decimals with a cell format does not change the value; totals still use the real value. To calculate with the rounded value, you need a function such as ROUNDUP.
- To make sure instalments cover the debt, round the instalment up:
=ROUNDUP(B2/12,2).
In Nexell
Get Nexell to do it from a sentence
Add a Boxes column to the order list that divides the order quantity by the box size and rounds up
Convert to tableBring your order list into the tool and type this. Nexell adds the Boxes column with real Excel formulas and shows it in the preview; in the downloaded file, the box count changes when the quantity does.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
What is the difference between ROUNDUP and CEILING.MATH?
ROUNDUP works by digits: decimals, tens or hundreds. CEILING.MATH rounds up to a multiple you choose: of 12, 0.5 or 50. They also differ with negative numbers: ROUNDUP moves away from zero, while CEILING.MATH moves towards zero by default.