Excel ROUNDUP Formula: 10 Ways to Use It

Formulas & functions · Updated November 22, 2026

This listicle covers the ROUNDUP function in Microsoft Excel for Microsoft 365 on Windows, with Mac differences noted where they matter. Whether you’re a beginner trying to round a price or an analyst building complex financial models, these ten practical examples show you exactly how to use ROUNDUP to control decimal places, round to tens or hundreds, and even round time or dates. Each item includes a real formula, the cell layout it assumes, and the result you can expect.

1. Round a Single Number Up to Two Decimals

The most basic use: with a number in A1, enter =ROUNDUP(A1,2) in B1. For A1 = 3.14159, the result is 3.15. The second argument is the number of decimal places; use 0 for whole numbers, 1 for one decimal, and so on. On Mac, the formula works identically; just type it in the formula bar.

2. Round Up to the Nearest Whole Number

Set the second argument to 0: =ROUNDUP(A1,0). If A1 = 4.01, the result is 5. This is useful for inventory counts where you always need a full unit, even if you only have a fraction of one. Unlike INT or TRUNC, ROUNDUP always rounds away from zero, so negative numbers like -4.2 become -5.

3. Round Up to the Nearest Ten, Hundred, or Thousand

Use a negative number for the second argument. For example, =ROUNDUP(A1,-1) rounds up to the nearest ten; =ROUNDUP(A1,-2) to the nearest hundred; =ROUNDUP(A1,-3) to the nearest thousand. With A1 = 1234, =ROUNDUP(A1,-2) returns 1300. This is great for estimating budgets or rounding up sales targets.

4. Round Up a Price to the Nearest Cent (Two Decimals)

When dealing with currency, you often need to round up to the cent. With a price in A1, use =ROUNDUP(A1,2). For A1 = 19.999, the result is 20.00. This ensures you never undercharge due to floating-point errors. Note that Excel’s number format may display 20.00, but the underlying value is exactly 20.

5. Round Up a Percentage to Two Decimals

If you have a percentage like 0.123456 in A1 and you want to show 12.35%, use =ROUNDUP(A1,4) because the percentage format multiplies by 100. For A1 = 0.123456, the result is 0.1235, which displays as 12.35%. Alternatively, you could use =ROUNDUP(A1*100,2)/100, but the first method is cleaner.

6. Round Up Time to the Nearest Hour

Excel stores time as fractions of a day, so to round up to the nearest hour, multiply by 24, round up, then divide by 24. With a time in A1 (e.g., 8:15 AM), use =ROUNDUP(A1*24,0)/24. The result is 9:00 AM. For nearest 15 minutes, multiply by 96 (24*4), round up, then divide by 96.

7. Round Up Dates to the Next Week

Dates are stored as serial numbers, so you can round them up to the next week by using =ROUNDUP(A1/7,0)*7. With a date in A1 (e.g., 3/15/2024, which is a Friday), the result is 3/21/2024 (the next Thursday, depending on your week start). This is handy for weekly billing cycles. To round up to the next month, use =EOMONTH(A1,0)+1 instead, since ROUNDUP doesn’t work well with months.

8. Round Up a Calculation in a Formula

You can nest ROUNDUP inside other formulas. For example, to round up the result of a division, use =ROUNDUP(B1/C1,0). With B1 = 10 and C1 = 3, the result is 4. This is common when calculating the number of boxes needed for shipping: =ROUNDUP(total_items/items_per_box,0).

9. Round Up to a Specified Multiple (Like 5 or 10)

Excel doesn’t have a direct CEILING for arbitrary multiples, but you can combine ROUNDUP with division. To round up to the nearest 5, use =ROUNDUP(A1/5,0)*5. With A1 = 12, the result is 15. For nearest 0.05 (nickel), use =ROUNDUP(A1/0.05,0)*0.05. This works for any multiple.

10. Round Up with Conditional Logic (IF + ROUNDUP)

Sometimes you only want to round up if a condition is met. For instance, with a value in A1 and a threshold in B1, use =IF(A1>B1, ROUNDUP(A1,0), A1). If A1 = 5.2 and B1 = 5, the result is 6; if A1 = 4.8, the result is 4.8. This is useful for applying rounding rules only to certain rows.

How to Choose

When deciding between ROUNDUP and other rounding functions, consider your goal. Use ROUNDUP when you always want to round away from zero (up for positive, down for negative). Use ROUND for standard rounding to the nearest value, and ROUNDDOWN for always rounding toward zero. For rounding to a multiple, CEILING and FLOOR are more direct: =CEILING(A1,5) rounds up to the nearest 5, while =ROUNDUP(A1/5,0)*5 does the same but is more verbose. For time and date, consider MROUND for nearest multiple, but note it doesn’t always round up. Choose ROUNDUP when you need strict upward rounding, especially in financial calculations where you must never understate a cost.

Frequently Asked Questions

Q: What’s the difference between ROUNDUP and CEILING?
A: ROUNDUP rounds to a specified number of decimal places, while CEILING rounds up to a specified multiple. For example, ROUNDUP(12.34,1) gives 12.4, but CEILING(12.34,0.1) also gives 12.4. For whole numbers, CEILING(12.34,1) gives 13, while ROUNDUP(12.34,0) also gives 13.

Q: Does ROUNDUP affect negative numbers differently?
A: Yes, ROUNDUP always rounds away from zero. So ROUNDUP(-1.2,0) returns -2, not -1. If you want to round up toward positive infinity (so -1.2 becomes -1), use CEILING with a positive significance.

Q: Can I use ROUNDUP in Google Sheets?
A: Yes, the syntax is identical. In Google Sheets, ROUNDUP(A1,2) works the same way. The only difference is that some functions like CEILING have slightly different arguments, but ROUNDUP is the same.

Q: Why does my ROUNDUP formula show 20.00 but the cell says 19.99?
A: That’s likely a formatting issue. The formula result is exactly 20, but the cell’s number format may be set to show only two decimals, and if the original value is 19.999, the displayed result should be 20.00. Check the cell format and ensure the formula is correct.

Q: Is there a way to round up to the nearest 5 cents without using ROUNDUP?
A: Yes, you could use =CEILING(A1,0.05), which is simpler. But if you prefer ROUNDUP, use =ROUNDUP(A1/0.05,0)*0.05. Both give the same result.

Final Thoughts

The ROUNDUP function is a simple yet powerful tool for controlling how numbers are displayed and used in calculations. By mastering the ten scenarios above, you can handle everything from basic rounding to complex conditional logic. Remember that ROUNDUP always rounds away from zero, so test your formulas with both positive and negative numbers to ensure they behave as expected. With these examples, you’re ready to round up any data in your spreadsheets.

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.