ROUNDUP rounds a number away from zero to a specified number of digits. It always increases the absolute value, so 2.1 becomes 3 when rounding to whole numbers, and -2.1 becomes -3.
=ROUNDUP(number, num_digits)What does ROUNDUP do?
ROUNDUP is one of Excel's Math & Trig functions. It takes a number and a digit count and rounds the number away from zero, no matter how small the discarded part is. Unlike standard rounding, which looks at the next digit, ROUNDUP always moves up in magnitude: 4.01 becomes 5 when rounding to zero decimal places, and -4.01 becomes -5.
This matters whenever you need a guaranteed ceiling rather than a best guess. Pricing, packaging, staffing, and budgeting often require you to round up so you never fall short. ROUNDUP gives you that certainty in a single formula and works the same on positive and negative values.
For example, a supplier selling cable in 10-metre reels needs to know how many reels to order for a 47-metre job. Dividing 47 by 10 gives 4.7, but you cannot buy part of a reel. =ROUNDUP(47/10,0) returns 5, so you order five reels and avoid a second delivery.
When to use ROUNDUP
- Calculating how many boxes, reels, or pallets to order when only whole units are sold.
- Setting a price to the next whole pound or dollar so no pennies are lost.
- Working out billable hours or days, rounding up to the next half hour or full day.
- Estimating staffing or seating needs where a partial person or seat is impossible.
- Applying a safety margin to quantities or costs in a budget.
ROUNDUP syntax
=ROUNDUP(number, num_digits)| Argument | Required? | What to enter |
|---|---|---|
number | Required | The value you want to round. It can be a number, a cell reference, or a calculation such as 47/10. Example: =ROUNDUP(4.2,0) returns 5. |
num_digits | Required | How many digits to keep after rounding. Use 0 for a whole number, a positive number for decimal places, or a negative number to round to tens, hundreds, and so on. Example: =ROUNDUP(1234,-2) returns 1300. |
What it returns: ROUNDUP returns a number rounded away from zero to the specified number of digits. The result is always greater than or equal to the original number in absolute value.
ROUNDUP examples
1 Round a price up to the next whole dollar
The goal is to turn a cost with cents into a clean selling price that never loses money. The formula =ROUNDUP(B2,0) looks at the value in B2, ignores the decimal part, and moves the number up to the next whole dollar. For 12.01 it returns 13, and for 12.99 it also returns 13. This guarantees the price covers the cost plus a small buffer.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Cost | |||
| 2 | Notebook | 12.01 | 13 | ||
| 3 | Pen pack | 4.99 | |||
| 4 | Folder | 7.5 | |||
| 5 | Stapler | 15.25 | |||
| 6 |
2 Round up to one decimal place
Here you need one decimal place for a measurement report. The formula =ROUNDUP(B2,1) keeps one digit after the decimal point and rounds the rest away from zero. A value of 3.14 becomes 3.2, and 3.10 stays 3.1 because the discarded part is zero. The result is a consistent one-decimal figure that is never lower than the original.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Sample | Reading | |||
| 2 | S1 | 3.14 | 3.2 | ||
| 3 | S2 | 2.71 | |||
| 4 | S3 | 5.05 | |||
| 5 | S4 | 4.1 | |||
| 6 |
3 Round up to the nearest ten
You are ordering printed flyers in packs of ten and want to know how many packs to buy. The formula =ROUNDUP(B2/10,0)*10 divides the quantity by 10, rounds that result up to a whole number, then multiplies by 10. For 47 flyers, 47/10 is 4.7, which rounds up to 5, and 5 times 10 is 50. You order 50 flyers, enough to cover the request.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Event | Flyers needed | |||
| 2 | Workshop | 47 | 50 | ||
| 3 | Seminar | 23 | |||
| 4 | Fair | 88 | |||
| 5 | Meetup | 15 | |||
| 6 |
4 Calculate billable hours in half-hour blocks
A consultant bills in half-hour blocks and needs to round actual time up. The formula =ROUNDUP(B2*2,0)/2 multiplies hours by 2 to convert to half-hour units, rounds up to a whole unit, then divides by 2. For 1.25 hours, 1.25 times 2 is 2.5, which rounds up to 3, and 3 divided by 2 is 1.5. The client is billed for 1.5 hours.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Client | Hours worked | |||
| 2 | Acme | 1.25 | 1.5 | ||
| 3 | Beta | 2.1 | |||
| 4 | Gamma | 0.75 | |||
| 5 | Delta | 3 | |||
| 6 |
5 Round up a total to the nearest hundred for a budget
You are preparing a budget and want each department total rounded up to the next hundred for a safety margin. The formula =ROUNDUP(B2,-2) uses a negative digit count to round to hundreds. For 1234, it returns 1300; for 987, it returns 1000. This gives a conservative budget figure that is easy to read and always covers the actual cost.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Department | Estimated cost | |||
| 2 | Marketing | 1234 | 1300 | ||
| 3 | IT | 987 | |||
| 4 | HR | 456 | |||
| 5 | Facilities | 2101 | |||
| 6 |
Common ROUNDUP errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | The number or num_digits argument contains text that cannot be converted to a number, such as a word or a cell with a stray space. | Check that both arguments are numeric or refer to numeric cells. Remove text or use VALUE to convert text numbers. |
| #NAME? | The function name is misspelled, for example ROUNDUP written as ROUNDUP with a space or as ROUND_UP. | Type =ROUNDUP( and let Excel suggest the function, or correct the spelling. |
| #NUM! | The num_digits argument is extremely large or the calculation produces a number outside Excel's limits. | Use a sensible digit count, typically between -15 and 15, and check the underlying numbers. |
| Wrong direction result | Using ROUNDUP when you expected standard rounding, so 2.1 becomes 3 instead of 2. | If you want normal rounding, use ROUND; if you want always down, use ROUNDDOWN. |
Tips for using ROUNDUP
- Use a negative num_digits to round up to tens, hundreds, or thousands:
=ROUNDUP(1234,-2)returns 1300. - Combine ROUNDUP with division and multiplication to round to a custom step, such as packs of 10:
=ROUNDUP(B2/10,0)*10. - Remember that ROUNDUP works away from zero, so negative numbers become more negative: -2.1 rounds to -3.
- To round up to the next half hour, multiply by 2, round up, then divide by 2:
=ROUNDUP(B2*2,0)/2. - Use ROUNDUP on the final result rather than on intermediate steps to avoid compounding rounding differences.
Frequently asked questions
What is the difference between ROUNDUP and ROUND?
ROUND rounds to the nearest value based on the next digit, so 2.4 becomes 2 and 2.6 becomes 3. ROUNDUP always rounds away from zero, so both 2.1 and 2.9 become 3.
How do I round up to the nearest 10 in Excel?
Use a negative digit count: =ROUNDUP(A1,-1) rounds up to the nearest ten, and =ROUNDUP(A1,-2) rounds up to the nearest hundred.
Does ROUNDUP work with negative numbers?
Yes. ROUNDUP rounds away from zero, so -2.1 becomes -3 when rounding to zero decimal places. The absolute value always increases.
Can I use ROUNDUP inside another formula?
Yes. ROUNDUP is often nested, for example =ROUNDUP(SUM(B2:B10),0) rounds up a total, or =ROUNDUP(B2/10,0)*10 rounds up to a multiple of 10.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. ROUNDUP reference