If A2 contains 12.341, enter =ROUNDUP(A2,2) to get 12.35: ROUNDUP moves a number away from zero to the requested place. This guide explains its arguments, decimal and negative-digit settings, how it differs from other rounding functions, and how to use it reliably in Microsoft Excel for Microsoft 365 on Windows.
1. Understand the ROUNDUP syntax
ROUNDUP has two arguments: the number to round and the number of digits to keep, written as ROUNDUP(number, num_digits) when describing its structure. The first argument can be a cell reference, a calculation, or a numeric value; the second controls the rounding position rather than the number of decimal places displayed on the screen. For example, with the value 6.283 in A2, =ROUNDUP(A2,1) returns 6.3, because Excel keeps one digit after the decimal point and raises the magnitude to the next tenth.
2. Round upward to a chosen decimal place
Use a positive num_digits value to round to decimal places: 1 means tenths, 2 means hundredths, and 3 means thousandths. With 8.231 in A2, =ROUNDUP(A2,2) returns 8.24, since the nonzero third decimal place means the hundredths place must increase. ROUNDUP always moves away from zero, so it does not merely inspect whether the discarded digits are five or greater; even a small discarded fraction causes the retained value to move up in magnitude.
3. Use zero to round to a whole number
Set num_digits to 0 when you want an integer result, without decimal places. With 8.231 in A2, =ROUNDUP(A2,0) returns 9, because the positive value is between 8 and 9 and rounding away from zero takes it to 9. This is different from formatting a cell to show zero decimal places: formatting changes the displayed appearance but leaves the underlying value unchanged, while ROUNDUP returns a rounded value that other calculations can use.
4. Round to the left of the decimal point
A negative num_digits value rounds to a place left of the decimal: -1 rounds to tens, -2 to hundreds, and -3 to thousands. With 1,234 in A2, =ROUNDUP(A2,-2) returns 1,300, rounding away from zero to the next hundred. This is useful when a report or estimate needs values grouped at a broader scale, but remember that the returned number is a multiple of the selected power of ten, not a value simply displayed with fewer digits.
5. See how ROUNDUP treats negative numbers
For a negative number, away from zero means the result becomes more negative, not closer to zero. With -3.141 in A2, =ROUNDUP(A2,2) returns -3.15; rounding it to two decimal places does not produce -3.14. This sign behavior matters in tables containing gains and losses, temperature changes, or adjustments, because the same rule applies on both sides of zero: ROUNDUP increases the absolute value whenever discarded digits are nonzero.
6. Choose between ROUNDUP, ROUND, and ROUNDDOWN
ROUNDUP always moves away from zero, ROUND uses standard rounding, and ROUNDDOWN moves toward zero by dropping the excess at the chosen position. With 4.274 in A2, =ROUNDUP(A2,2) returns 4.28, while =ROUND(A2,2) returns 4.27 and =ROUNDDOWN(A2,2) also returns 4.27. The distinction can be important when a rule requires a guaranteed minimum quantity or conservative upward estimate; ROUND is appropriate when ordinary nearest-value rounding is wanted, and ROUNDDOWN when the magnitude must not increase.
7. Decide whether to round a final result or an intermediate value
When ROUNDUP wraps a calculation, Excel evaluates the calculation first and then rounds its result. With A2 set to 1.201 and B2 set to 1.001, =ROUNDUP(A2*B2,2) returns 1.21 because the product is 1.202201; if each stage has its own rule, =ROUNDUP(ROUNDUP(A2,2)*B2,2) returns 1.22 instead. Rounding at different stages can change the outcome, so apply it only where the worksheet’s stated process calls for it rather than inserting ROUNDUP automatically into every calculation.
8. Use a different function for a fixed increment
ROUNDUP rounds according to decimal position, so it cannot directly say “round to the next multiple of 0.05” or “the next multiple of 25.” For an increment, use CEILING.MATH instead: with 1.231 in A2, =CEILING.MATH(A2,0.05) returns 1.25, the next multiple of five hundredths. The choice is about the rounding unit: ROUNDUP with 2 digits works in hundredths generally, while CEILING.MATH with 0.05 uses specific 0.05 steps; check the intended treatment of negative values if your data includes them.
9. Apply ROUNDUP down a column
For a list of measurements in A2:A6, enter =ROUNDUP(A2,1) in B2 and copy the formula down through B6; each row then rounds its corresponding A-cell value to one decimal place. The relative reference changes from A2 to A3, A4, and so on as the formula is copied, which lets one formula pattern handle a range without editing each row. In Excel for Microsoft 365 on Windows, you can drag the fill handle at the lower-right corner of B2 down the range; the same fill-handle method is available in Excel for Mac, though ribbon layout can vary slightly by update.
10. Distinguish a rounded value from rounded display
Number formatting can make a value look rounded without changing the value used in later calculations. If A2 contains 12.341, applying a number format that displays two decimal places may show 12.34, whereas =ROUNDUP(A2,2) returns the actual result 12.35 in its formula cell. To check which situation you have, select the cell and inspect the formula bar or increase the displayed decimal places from the Home tab; use ROUNDUP when later formulas must receive the rounded result, and formatting when only the presentation should change.
How to Choose
Start by deciding what the rounding rule actually means. If the instruction is to move to a certain decimal position in the direction away from zero, ROUNDUP is the direct choice; select 0 for whole numbers, a positive digit count for decimal places, or a negative digit count for tens, hundreds, and larger place values. Then check the sign of the data, because negative values move farther below zero under ROUNDUP.
Next, determine whether you need a place value or a custom increment. A requirement such as “nearest hundredth, always upward” fits ROUNDUP with 2 digits, while “next multiple of 0.05” calls for CEILING.MATH with a significance of 0.05. Finally, decide whether the rounded value should feed future calculations or merely look rounded in a report. A formula changes the calculated result; cell formatting changes only what Excel displays, so those approaches are not interchangeable.
Frequently Asked Questions
Does ROUNDUP always round to the next larger number?
It always rounds away from zero, which is not always the same as moving toward the larger number on the number line. A positive value such as 2.31 rounded to an integer becomes 3, while a negative value such as -2.31 becomes -3.
What happens if the number is already exact at the chosen place?
If there are no nonzero digits beyond the requested place, the result stays the same. For example, rounding 4.5 to zero decimal places leaves it at 5, while rounding 4.00 to two decimal places leaves it at 4.00 in value; the cell’s number format determines whether trailing zeros are visible.
Can I use ROUNDUP to round to the nearest quarter?
Not directly with a digit count, because quarters are increments of 0.25 rather than a decimal position. Use CEILING.MATH with a significance of 0.25 when the rule is to move up to the next quarter-step, and confirm the intended direction for negative values before applying it to mixed-sign data.
Why does a cell show more decimals than the ROUNDUP formula requests?
The formula result may be rounded while the cell is formatted to display extra decimal places or a general number format. Check the formula bar and the cell’s number format; the value returned by ROUNDUP and the number of digits shown on screen are separate settings.
Is ROUNDUP the same as Excel’s Increase Decimal button?
No. Increase Decimal changes the displayed precision of selected cells and does not alter their underlying values. ROUNDUP creates a rounded result that can be referenced by other formulas, so choose it when the calculation itself must use the rounded number.
Final Thoughts
ROUNDUP is straightforward once you separate direction from position: it moves values away from zero, while num_digits sets the place to round. Use it for directional rounding, CEILING.MATH for fixed increments, and number formatting when you only need a different display. Checking the sign, rounding stage, and intended output before filling a formula down a worksheet helps prevent subtle differences in results.
Related
- Group Dates in Excel Filters: Steps, Fixes, and Tips
- Grocery List Excel Template: Free Options and Setup
- How to Password Protect an Excel Workbook in Windows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Dependent Drop-Down List: 3 LevelsYes. In Excel for Microsoft 365, you can build a three-level dependent drop-down list with a source table,…
- How to Archive Emails in the New Outlook for WindowsTo archive an email in the new Outlook, select it and choose Archive on the message toolbar. Outlook…
- XLOOKUP vs VLOOKUP in Google Sheets: Which to Use?In Google Sheets, XLOOKUP is usually the more flexible choice: it can search in either direction, uses exact…
- How to Insert a Horizontal Line in WordIn Microsoft Word for Microsoft 365 on Windows, type three hyphens on an otherwise empty paragraph and press…
- Excel Data Validation List AutoFill: What Works?Excel can autocomplete some data-validation dropdown lists in current Microsoft 365 versions, but the feature is not available…
- How to Edit a PivotTable in ExcelTo edit a PivotTable in Excel for Microsoft 365 on Windows, click any cell inside it, then use…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.