Skip to content

Excel function · Math

Excel ROUNDUP function

ROUNDUP always rounds a number up to the number of digits you give, whatever the part being dropped: 10.42 boxes become 11. Use it for quantities that must be topped up to cover a need.

In Turkish Excel: YUKARIYUVARLA

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

English Excel=ROUNDUP(number, num_digits)
Turkish Excel=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

ArgumentRequiredDescription
numberRequiredThe number to round, or a formula that produces it, e.g. B2/C2.
num_digitsRequiredThe 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.

D2fx=ROUNDUP(B2/C2,0)
Top an order quantity up to whole boxes: example table
ABCD
1ItemOrder QtyBox SizeBoxes
2Notebook2502411
3Pen120010012
4Binder87128
5Eraser5004811
  • 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.

D2fx=B2*(1+C2)
Take the label price up to the next ten: example table
ABCDE
1ItemCostMarginCalculated PriceLabel Price
2Flask412.4035%556.74560
3Mug86.9040%121.66130
4Bottle233.0030%302.90310
5Tea Set1,189.5025%1,486.881,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

Type this in Nexell

Add a Boxes column to the order list that divides the order quantity by the box size and rounds up

Convert to table

Bring 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.

Related functions

All math functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free