Excel ROUNDUP Formula: 10 Ways to Use It

Formulas & functions · Updated November 22, 2026

This article lists 10 practical ways to use Excel’s ROUNDUP function, from basic rounding to combining it with other functions for real-world tasks. It’s written for Excel users who already know the basics but want to master rounding up in formulas. You’ll get specific formulas, cell layouts, and expected results for each scenario.

1. Basic ROUNDUP Syntax

The core formula is =ROUNDUP(number, num_digits). For example, with 123.456 in cell A1, =ROUNDUP(A1, 2) returns 123.46, and =ROUNDUP(A1, 0) returns 124. The second argument tells Excel how many decimal places to keep; use 0 to round to the nearest whole number, negative numbers to round to tens, hundreds, etc.

2. Round Up to the Nearest Whole Number

Use =ROUNDUP(A2, 0) to force any decimal up to the next integer. For instance, if A2 contains 4.01, the result is 5. This is useful for counting items that can’t be fractional, like people or boxes. Remember, ROUNDUP always rounds away from zero, so negative numbers like -4.2 become -5.

3. Round Up to the Nearest 10, 100, or 1000

Use negative numbers for the second argument: =ROUNDUP(A3, -1) rounds up to the nearest 10, =ROUNDUP(A3, -2) to the nearest 100, and so on. With 123 in A3, =ROUNDUP(A3, -1) returns 130. This is handy for estimating budgets or quantities in bulk.

4. Round Up Currency to Two Decimals

For financial figures, use =ROUNDUP(B2, 2) to ensure prices or totals always round up to the nearest cent. For example, if B2 contains 19.999, the formula returns 20.00. This is common in tax calculations where you must round up to avoid undercharging. Note that Excel displays 20.00 only if the cell is formatted as currency.

5. Round Up Time to the Nearest 15 Minutes

To round a time up to the next quarter-hour, use =ROUNDUP(C2*96, 0)/96 because a day has 96 quarter-hours. If C2 contains 9:07 AM, the formula returns 9:15 AM. Format the result as a time. This works for any interval: for 30 minutes, multiply by 48; for 5 minutes, multiply by 288.

6. Round Up a Percentage to a Given Number of Digits

Percentages are stored as decimals, so to round a percentage up to two decimal places, use =ROUNDUP(D2, 2) and format the cell as a percentage. If D2 contains 0.12345, the result is 0.13, displayed as 13%. This is useful for interest rates or growth rates where you want to be conservative.

7. Round Up with CEILING for Multiples

While ROUNDUP rounds to a number of digits, CEILING rounds to a specified multiple. Use =CEILING(E2, 5) to round up to the nearest multiple of 5. If E2 contains 12, the result is 15. CEILING is better when you need exact multiples, like packaging items in boxes of 5. For negative numbers, CEILING rounds toward zero, unlike ROUNDUP.

8. Combine ROUNDUP with SUM

To round up a total, nest SUM inside ROUNDUP: =ROUNDUP(SUM(F2:F10), 0). With values 1.2, 2.3, and 3.4 in F2:F4, SUM gives 6.9, and the formula returns 7. This ensures a total is never understated. You can also use it with other functions like AVERAGE.

9. Use ROUNDUP with IF for Conditional Rounding

Combine ROUNDUP with IF to round up only when a condition is met. For example, =IF(G2>100, ROUNDUP(G2, 0), G2) rounds up values over 100 to the nearest integer, leaving others as is. If G2 contains 150.5, the result is 151; if 99.9, it stays 99.9. This is useful for tiered pricing or thresholds.

10. Round Up with SUMPRODUCT for Weighted Averages

Use =ROUNDUP(SUMPRODUCT(H2:H10, I2:I10)/SUM(I2:I10), 1) to round up a weighted average to one decimal. With H2:H10 as values and I2:I10 as weights, this gives a conservative average. For example, values 10 and 20 with weights 1 and 2 yield (10+40)/3=16.666…, rounded up to 16.7. This is great for grading or performance metrics.

How to Choose

Decide between ROUNDUP and CEILING based on whether you need digit-based rounding or multiple-based rounding. ROUNDUP is more flexible for decimal places; CEILING is clearer for fixed increments. Also consider the sign: ROUNDUP always rounds away from zero, while CEILING rounds toward zero for negatives. For time rounding, the multiply-by-96 trick is specific to ROUNDUP. Always test with your actual data to confirm the result.

Frequently Asked Questions

Q: Does ROUNDUP always round up, even for negative numbers?
A: Yes, ROUNDUP rounds away from zero. So -2.1 becomes -3. If you want to round toward zero, use ROUNDDOWN.

Q: Can I round up to a specific number of significant figures?
A: Excel doesn’t have a direct ROUNDUP for significant figures, but you can use =ROUNDUP(A1, 1 - INT(LOG10(ABS(A1)))) for one significant figure. Adjust the 1 to change the count.

Q: What’s the difference between ROUNDUP and CEILING?
A: ROUNDUP rounds to a number of decimal places; CEILING rounds to a specified multiple. For example, ROUNDUP(12.5, 0) gives 13, while CEILING(12.5, 5) gives 15.

Q: Why does my ROUNDUP formula show 20.00 but the cell shows 20?
A: The result is correct; the display depends on number formatting. Apply a currency format to show two decimals.

Q: How do I round up to the nearest whole number in Google Sheets?
A: Use the same ROUNDUP function. Google Sheets supports it identically, so =ROUNDUP(A1, 0) works there too.

Q: Can ROUNDUP handle text or errors?
A: No, it requires a numeric value. If the cell contains text, ROUNDUP returns #VALUE!. Use IFERROR to handle such cases.

Final Thoughts

ROUNDUP is a simple but powerful function that ensures your numbers never round down, which is critical in billing, inventory, and time tracking. The 10 formulas above cover the most common scenarios, from basic rounding to advanced combinations. Start with the basic syntax, then adapt the examples to your own data. With practice, you’ll find ROUNDUP indispensable in your Excel toolkit.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.