To round a number up in Excel, use ROUNDUP with the number and the number of digits to keep. With a value of 12.341 in A2, enter =ROUNDUP(A2,2) to return 12.35. This guide explains ten practical ways to use the function, including rounding to whole numbers, handling negative values, and calculating package or time-block quantities; it is for Excel users who want results that always round away from zero rather than to the nearest value.
1. Round a value up to a whole number
With a decimal value in A2, enter =ROUNDUP(A2,0) to return the next whole number away from zero when a fraction is present; for example, 7.01 becomes 8, while 7 remains 7. The zero tells Excel to keep no digits to the right of the decimal point, and the result stays numeric, so you can use it in later calculations. This is useful when a partial person, item, or task cannot be counted as a whole unit, but remember that it rounds negative values farther from zero too: -7.01 becomes -8.
2. Keep a chosen number of decimal places
With 12.341 in A2, enter =ROUNDUP(A2,2) to return 12.35, keeping two decimal places while pushing any discarded fraction upward. Change the second argument to 1 for one decimal place or 3 for three; the function calculates the numeric result, while the cell’s number format controls how many digits are displayed. This is useful for measurements or intermediate calculations where rounding down could understate a required amount, but it is not the same as formatting a cell to show two decimals, which can leave the underlying value unchanged.
3. Round up to the next ten, hundred, or thousand
With 146 in A2, enter =ROUNDUP(A2,-1) to get 150; the negative digit count tells Excel to round to the left of the decimal point. Use -2 to round to hundreds, so 1,234 becomes 1,300, or -3 for thousands, so 1,234 becomes 2,000. This is handy for high-level estimates, capacity planning, or grouping quantities into broader units, and it follows ROUNDUP’s away-from-zero rule for negative numbers as well: -146 rounded with -1 becomes -150.
4. Round up to a custom increment
ROUNDUP rounds by decimal position, not directly to increments such as five cents or 0.25, so divide by the increment, round the quotient to a whole number, and multiply back. With a price of 12.31 in A2 and an increment of 0.05 in B2, enter =ROUNDUP(A2/B2,0)*B2 to return 12.35. This pattern works for other positive increments too, such as 0.25 for quarter-unit steps or 10 for groups of ten; use cells for the value and increment so the calculation is easy to audit and change.
5. Calculate the number of full packages or cartons
With the number of individual units in A2 and units per carton in B2, enter =ROUNDUP(A2/B2,0) to calculate how many cartons are needed. For example, 23 units divided into cartons of 6 gives 3.833 cartons, which ROUNDUP makes 4, so the full order can be packed. This is valuable for ordering and shipping because a partial carton still requires one physical carton; verify that B2 is greater than zero, since dividing by a blank or zero cell will produce an error rather than a meaningful package count.
6. Bill or schedule time in fixed blocks
With 2.1 hours in A2 and a billing or scheduling block of 0.25 hours in B2, enter =ROUNDUP(A2/B2,0)*B2 to return 2.25 hours. The calculation counts the number of quarter-hour blocks needed, then converts that count back to hours; the same pattern works for a 0.1-hour increment or a 30-minute block entered as 0.5. This is useful for planning durations when partial blocks must be counted as a complete block, but treat the increment as a stated rule rather than assuming it matches a company policy or contract.
7. Add a percentage allowance, then round to whole units
With a base requirement of 37 units in A2 and an allowance of 8% in B2, enter =ROUNDUP(A2*(1+B2),0) to return 40 units: 37 multiplied by 1.08 is 39.96, and rounding up produces 40. This is a compact way to include a planned buffer for breakage, trim, or other expected loss before converting a fractional estimate into whole items. Keep the percentage in a cell formatted as a percentage, and make sure it represents the intended allowance; ROUNDUP does not decide whether the buffer itself is appropriate.
8. Round a date-time value up to the next date
With an Excel date-time value in A2, enter =ROUNDUP(A2,0) to remove its fractional time portion by rounding the underlying date serial number upward. A time such as 9:15 a.m. makes the serial value greater than its whole-number date, so the result is the following midnight; a value already at midnight stays on that date. Format the result cell as a date using Home > Number Format if it displays as a serial number. This can help assign after-hours records to the next calendar day, but it is not a substitute for a business-day or time-zone rule.
9. Apply ROUNDUP only to positive values
With a value in A2, enter =IF(A2>0,ROUNDUP(A2,0),A2) to round positive numbers up to a whole number while leaving zero and negative values unchanged. For example, 4.2 becomes 5, while -4.2 remains -4; this is different from ROUNDUP alone, which would make -4.2 become -5. The IF wrapper is useful when a workbook has a specific rule for positive quantities but should preserve credits, adjustments, or negative readings, and it makes that exception visible in the formula rather than hiding it in cell formatting.
10. Round a total instead of every line
With amounts in B2:B6, enter =ROUNDUP(SUM(B2:B6),0) to add the values first and then round the combined total up to a whole number. For example, if the five entries total 10.2, this returns 11; rounding each entry separately before adding could produce a different and larger result. This distinction matters in summaries, estimates, and reports because the order of operations changes the answer. Use this pattern when the rule applies to the grand total, and round individual rows only when the underlying process specifically requires each row to be rounded on its own.
How to Choose
Start by identifying what must be rounded: decimal places, whole units, a place to the left of the decimal, or a custom increment. For decimal positions, choose the second argument by counting places: 2 keeps hundredths, 0 keeps whole numbers, and -1 rounds to tens. For a custom step such as 0.05 or 0.25, use the divide-round-multiply pattern rather than expecting ROUNDUP to recognize the increment by itself.
Next, decide whether the rule applies to each input or to a combined result. Rounding each line before totaling can produce a different answer from totaling first and rounding once, so match the formula to the rule being modeled. Also check how negative values should behave: ROUNDUP always moves away from zero when it discards a nonzero fraction, which may be wrong for credits or signed measurements. Finally, remember that number formatting changes the display, not the stored value. ROUNDUP is available in Microsoft 365 Excel for Windows; the same function and formula syntax are available in Excel for Mac, though ribbon layout can differ. In some regional settings, Excel uses semicolons instead of commas between arguments.
Frequently Asked Questions
Does ROUNDUP always round away from zero?
Yes. When digits are discarded, positive values move higher and negative values move lower. For example, rounding -2.31 to one decimal place gives -2.4, not -2.3.
What is the difference between ROUNDUP and ROUND?
ROUNDUP always rounds away from zero when a remainder is present. ROUND rounds to the nearest value, using the next digit to decide whether to round up or down, so it can produce a smaller result than ROUNDUP.
Does ROUNDUP change the original cell?
No. A formula returns a rounded result in its own cell and leaves the source value intact. If you need to replace source values, make a backup first and use a deliberate copy-and-paste-values workflow.
Why does my result show extra decimal places?
The formula determines the numeric result, but the cell format determines how it appears. Select the result cell and use Home > Number Format to choose an appropriate display, such as Number with two decimal places.
Can ROUNDUP round to the nearest five cents?
Not by itself, because its digits argument refers to decimal places rather than arbitrary increments. Divide the value by 0.05, round the quotient to a whole number, and multiply by 0.05; check the result and the intended rule when working with currency amounts.
Final Thoughts
ROUNDUP is useful when a partial amount must count as the next complete unit, but its direction and precision should be intentional. Choose the correct digits argument, account for negative values, and decide whether to round each row or only the final total. For custom increments, use the divide-round-multiply approach and verify it against a simple example before filling the formula down a worksheet.
Related
- Undo vs Redo Excel: What Each Command Does
- Ungroup Excel Shortcut: Remove Row and Column Groups
- Excel Custom Number Formats: How to Create and Use Them
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Use XLOOKUP in Excel: A Step-by-Step Formula GuideTo retrieve a value with XLOOKUP, identify the value to search for, the range where it appears, and…
- Excel COUNTIF: Find Text From a ListTo count cells that contain any text from a list in Excel for Microsoft 365, use =SUM(COUNTIF(A2:A10,"*"&C2:C4&"*")), where…
- Excel COUNTIF: Count Dates Between Two DatesTo count dates in a column that fall between a start date and an end date, use COUNTIFS,…
- Lock a Named Range in an Excel Formula?Usually, you do not need to add dollar signs to lock a named range in an Excel formula:…
- Excel COUNTIF No Duplicates: Count Unique ValuesThe direct answer: Excel has no single “COUNTIF no duplicates” function, but you can count unique values (ignoring…
- Oracle String Functions Explained with ExamplesOracle string functions operate on character data in SQL and PL/SQL. For everyday work, use functions such as…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.