Does Excel Have a ROUNDUP Function? Here’s How It Works

Formulas & functions · Updated November 19, 2026

Yes—Excel has a ROUNDUP function, and it rounds a number away from zero to the number of decimal places you specify. In Microsoft Excel for Microsoft 365 on Windows, enter a formula such as =ROUNDUP(A2,2) to round the value in A2 up to two decimal places. The examples below explain the digits argument, negative numbers, practical uses, and related functions, so you can choose the right approach for a worksheet.

1. The ROUNDUP Function

ROUNDUP is Excel’s built-in function for rounding a number away from zero, rather than rounding to the nearest value. With the number 3.14159 in A2, the formula =ROUNDUP(A2,2) returns 3.15, because the first two decimal places are retained and the remaining nonzero digits make the result move farther from zero. This behavior is useful when a calculation must not understate a quantity, such as estimating how many whole containers or work shifts are needed.

You can enter the formula directly into a cell, or use the formula bar, and press Enter to calculate it; there is no special menu or add-in to enable. The function works in Excel for Microsoft 365 on Windows, Mac, and the web, although comma separators may display as semicolons in installations using regional settings that require them. Its key distinction is that up means away from zero, not always toward the larger positive number.

2. The Number of Digits Controls Precision

ROUNDUP accepts two arguments: the number to round and num_digits, which says where to round. With 8.421 in A2 and 1 in B2, =ROUNDUP(A2,B2) returns 8.5, retaining one digit to the right of the decimal point; changing B2 to 2 would return 8.43. The second argument can be a typed number or a reference to another cell, making it possible to adjust precision without editing the formula.

A positive digit count identifies decimal places, zero identifies the ones place, and a negative count identifies places to the left of the decimal point. This makes the function more flexible than simply increasing the number of displayed decimal places, because it changes the stored calculation result rather than only changing how the cell looks. Think of num_digits as the position where rounding stops, not as a request to add that many zeros.

3. Round Up to More Decimal Places

Use a positive num_digits when you need a result with a chosen level of decimal precision. With 3.14159 in A2, =ROUNDUP(A2,3) returns 3.142, while =ROUNDUP(A2,1) returns 3.2; both results move away from zero at the specified position. This is helpful for measurements, estimates, or calculated rates when you deliberately need to avoid reporting a smaller value than the underlying calculation supports.

Excel does not require the source number to contain as many visible decimal places as the result. For instance, if A2 contains 4.2 and you use two digits, the returned value is 4.20 numerically, but the cell might display 4.2 until you apply a number format that shows two decimal places. To control display, select the cell and use Home > Number to choose a format or adjust decimal places; formatting changes appearance, while ROUNDUP changes the calculated value.

4. Use Zero to Round Up to a Whole Number

Set num_digits to zero to round to the nearest whole-number position, always away from zero when there is a fractional part. With 7.01 in A2, =ROUNDUP(A2,0) returns 8, and with -7.01 in A2 the same formula returns -8. For positive inputs, the result is the next integer above the value; for negative inputs, it is the next integer below the value.

This is a common choice for counts that must be whole, such as the number of trips required to move a load or the number of batches needed to produce a target quantity. It does not mean Excel will always add one: if A2 already contains 7, rounding up to zero digits returns 7 because the value is already a whole number. Confirm whether the underlying task calls for a whole-number ceiling or ordinary rounding, since those rules produce different answers around a fractional value.

5. Use Negative Digits for Tens, Hundreds, and More

A negative num_digits rounds to the left of the decimal point, which is useful for producing rougher estimates or grouping values by place. With 1234 in A2, =ROUNDUP(A2,-2) returns 1300 because the function rounds away from zero to the nearest hundred position; using -1 instead returns 1240. The same rule applies to negative numbers, so a value such as -1234 rounded to -2 digits becomes -1300.

Negative digits do not mean that Excel subtracts from the value or changes its sign; the minus sign selects a place value. A result rounded to hundreds may be easier to scan in a summary, but it is less precise than the original amount, so keep the underlying source data if later calculations need exact values. You can use zero for ones, -1 for tens, -2 for hundreds, and -3 for thousands.

6. Know How ROUNDUP Differs from ROUND

ROUNDUP always moves a non-exact value away from zero, whereas ROUND rounds to the nearest value using the next digit to decide the result. With 2.341 in A2, =ROUNDUP(A2,2) returns 2.35, while =ROUND(A2,2) returns 2.34; the third decimal digit is 1, so ordinary rounding goes down to the nearest hundredth. This matters when requirements say always round up, because ROUND can move either direction.

The difference also applies to negative values: ROUNDUP makes a non-exact negative result more negative, while ROUND follows nearest-value rounding. Do not substitute one for the other based only on the fact that both accept a number and a digit count. Choose based on the rule required by the calculation, and use a small test value with a fractional part to verify the result before filling a formula down a long column.

7. Make the Precision Adjustable with a Cell Reference

Instead of hard-coding the number of places, put the desired precision in a separate cell so a user can change it quickly. With 12.345 in A2 and 2 in B2, =ROUNDUP(A2,B2) returns 12.35; changing B2 to 0 makes the same formula return 13. This setup is convenient for reusable reports where one version needs whole numbers and another needs a specified number of decimal places.

Label B1 clearly, for example Decimal places, and consider adding a note that negative values round to tens or hundreds rather than to decimal places. If you copy the formula down a list while the precision remains fixed in B2, use an absolute reference: with the values in A2:A10 and the fixed digit count in B2, =ROUNDUP(A2,$B$2) keeps the precision cell fixed as you fill down. The dollar signs lock the reference; they do not change the rounding rule.

8. Round a Total or Round Each Entry

Decide whether the requirement applies to each row separately or only to a combined total, because those operations can give different answers. With 2.21 in each of A2, A3, and A4, =ROUNDUP(SUM(A2:A4),1) returns 6.7 because the sum is 6.63 and the total is rounded once. With the same values, =SUMPRODUCT(ROUNDUP(A2:A4,1)) returns 6.9 because each 2.21 is rounded to 2.3 before the three results are added.

Neither result is universally correct: the right one depends on the real-world rule for the data. For instance, a process that assigns a separately rounded amount to every record may require row-by-row rounding, while a report that rounds only its final displayed total may require the first approach. The distinction is especially important in worksheets with many entries, where small per-row differences can accumulate.

9. Calculate the Number of Whole Packs Needed

ROUNDUP is useful for converting a division result into a whole number of required units. With 47 items to ship in A2 and a pack capacity of 12 in B2, =ROUNDUP(A2/B2,0) returns 4, because 47 divided by 12 is about 3.92 and three packs cannot hold all the items. This pattern also works for estimating the number of batches, boxes, trips, or teams needed when each unit has a fixed capacity.

Make sure the numerator and denominator use compatible units, and check that the capacity is greater than zero before relying on the result. If A2 is exactly 48 and B2 is 12, the formula returns 4 rather than 5, because the division produces an exact whole number and no extra pack is needed. This is one reason ROUNDUP is often clearer than adding one to a quotient, which would overcount exact divisions.

10. Compare Related Rounding Functions

Excel provides several alternatives for different rounding rules: ROUNDDOWN moves toward zero, ROUND chooses the nearest value, and CEILING.MATH rounds up to a specified multiple. With 1.231 in A2, =ROUNDDOWN(A2,2) returns 1.23, while with the same value in A2, =CEILING.MATH(A2,0.05) returns 1.25, the next multiple of five cents. ROUNDUP would instead round to a chosen decimal position, so the functions are not interchangeable.

Use TRUNC when you need to discard digits without rounding, and use INT only when rounding down to an integer is the intended rule; for negative values, INT goes to the next lower integer, unlike truncation toward zero. This family of functions lets you express the actual business or measurement rule rather than relying on cell formatting. These functions are available in Microsoft 365 Excel, and Excel for the web also supports the standard rounding functions discussed here.

How to Choose

Start by identifying the rule, not by looking for a function with the word up in its name. If every fractional result must move away from zero at a selected decimal place, use ROUNDUP; if the result should be nearest, choose ROUND; if excess digits should simply be removed, consider ROUNDDOWN or TRUNC. For a required increment such as the next 0.05 or 5 units, a multiple-based function such as CEILING.MATH is a better fit than selecting decimal digits.

Next, decide what position to round at and whether it applies per row or after aggregation. A zero digit count gives whole numbers, positive counts preserve decimal places, and negative counts round to tens, hundreds, or larger place values. Test both a positive and a negative fractional example if negative numbers can appear in the data, since away from zero can surprise users who assume up always means a larger numeric value.

Finally, keep calculation and display separate. A number format can show fewer decimal places without changing the underlying value, while a rounding formula changes what later calculations use. Use a formula when the rule is part of the calculation, apply formatting when the goal is only readability, and document adjustable inputs such as the digit count so the workbook remains understandable to the next person using it.

Frequently Asked Questions

Does Excel have a ROUNDUP function? Yes. It is a built-in function in Excel, and its basic form takes a number and a number-of-digits argument.

Does ROUNDUP always make a number larger? No. It rounds away from zero, so positive values move upward and negative values move downward, becoming more negative when they have digits to round.

How do I round up to the nearest whole number? Use a zero digit count in ROUNDUP. A positive value with a fractional part goes to the next integer, while an exact whole number stays unchanged.

Can ROUNDUP round to the nearest ten or hundred? Yes. Use -1 for tens, -2 for hundreds, and -3 for thousands in the digits argument.

Does changing decimal places in the ribbon do the same thing? No. Number formatting changes what Excel displays, but it normally leaves the stored value unchanged; a rounding formula returns a rounded value for further calculations.

Final Thoughts

Excel does have a ROUNDUP function, and its central rule is simple: it rounds away from zero at the position you specify. Choose the digits argument carefully, account for negative values, and decide whether to round individual entries or a final total. When you need a different rule—nearest value, a fixed increment, or truncation—use the corresponding rounding function rather than relying on formatting.

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.