Excel ROUNDUP Examples: 10 Practical Ways to Round

Excel’s ROUNDUP function always rounds a number away from zero, which makes it useful when a decimal result must not understate a quantity. These 10 examples show how to round decimals, measurements, averages, and calculated totals in Microsoft Excel for Microsoft 365 on Windows, with the assumed cell layout and result spelled out for each formula.

1. Round a decimal to two places

Suppose A2 contains 18.234 and you need a result to two decimal places; this is a common setup for measurements or values that need consistent precision. Enter =ROUNDUP(A2,2) in another cell, and Excel returns 18.24 because the third decimal place is nonzero and ROUNDUP increases the magnitude rather than rounding to the nearest value. Two decimal places are not automatically the right precision for every measurement, so choose the number of places that fits the data’s purpose instead of assuming that two is always appropriate.

2. Round to one decimal place

With a reading of 6.271 in A2, use =ROUNDUP(A2,1) in a separate cell to get 6.3. The second decimal place is enough to trigger the upward adjustment, while later digits do not change the number of places in the result. This can help standardize a column of readings when a report needs tenths, though it is worth keeping the original values in their own column if readers may need to inspect the underlying precision.

3. Round a positive value up to a whole number

If A2 contains 14.01 and a process needs an integer that fully covers that amount, enter =ROUNDUP(A2,0) in a result cell; the result is 15. Setting the second argument to zero removes the decimal places, and ROUNDUP moves any positive fractional value to the next integer rather than choosing the nearest integer. For comparison, an already whole value such as 14 stays 14, so the function does not add one merely because you asked for zero decimal places.

4. Round to the nearest hundred, upward

With 1,264 in A2, enter =ROUNDUP(A2,-2) to return 1,300. A negative second argument tells ROUNDUP to work to the left of the decimal point: -1 rounds to tens, -2 to hundreds, and -3 to thousands, always away from zero. This is handy for making a positive count or estimate easier to scan at a broad scale, but it deliberately overstates most non-rounded inputs, so keep the unrounded figure available when exact totals matter.

5. Round a negative number away from zero

Suppose A2 contains -7.231 and you need two decimal places; =ROUNDUP(A2,2) returns -7.24, not -7.23. “Up” here means away from zero, so the absolute size grows even though the displayed number becomes more negative; that behavior is an important distinction from the everyday meaning of rounding up on a number line. Check this carefully in datasets that include credits, temperature differences, or other signed values, because the result may surprise someone who expects ROUNDUP always to move toward positive infinity.

6. Find the number of full cartons required

Put the required item count, 47, in B2 and the carton capacity, 12, in C2; enter =ROUNDUP(B2/C2,0) in the result cell to get 4 cartons. Division gives about 3.92 cartons, and rounding that positive result to a whole number ensures that the final carton count can hold all 47 items rather than leaving a fraction of a carton. This pattern also works for trays, boxes, or other fixed-capacity containers; make sure the capacity cell is greater than zero, since division by zero cannot produce a useful count.

7. Schedule work in 15-minute blocks

Enter 37 in B2 for a task’s minutes and 15 in C2 for the allowed block size, then use =ROUNDUP(B2/C2,0)*C2 to return 45 minutes. Dividing by the block size converts the duration to 2.47 blocks, ROUNDUP makes that three complete blocks, and multiplying by 15 converts the answer back to minutes. The same structure can use a different positive block length in C2, which makes the sheet easy to reuse; it rounds to the next block when needed but leaves an exact multiple unchanged.

8. Round a length to a five-unit increment

If B2 holds a cut length of 62 centimeters and the material is handled in five-centimeter increments, enter =ROUNDUP(B2/5,0)*5 to get 65 centimeters. The formula first expresses the length as a number of five-centimeter units, rounds that unit count upward to 13, and multiplies back to the original unit. This is useful for planning material sold or prepared in fixed increments, but it does not measure a physical object more precisely; it produces a planning quantity that is at least as large as the input.

9. Round an average upward to one decimal place

Assume B2:B6 contain 2.3, 2.6, 2.8, 3.1, and 3.4, and enter =ROUNDUP(AVERAGE(B2:B6),1) in a result cell to get 2.9. The average is 2.84, so rounding that calculated value away from zero to one decimal place gives 2.9; the formula rounds the average, not each entry before averaging. That distinction matters when a report summarizes multiple readings, because rounding individual observations first can produce a different final summary.

10. Round a summed measurement to a whole unit

Place three segment lengths, 2.34, 3.28, and 4.11, in B2:B4, then enter =ROUNDUP(SUM(B2:B4),0) to return 10 whole units. Their total is 9.73, and ROUNDUP converts that total to the next whole number so the stated quantity covers the combined length. Applying the rounding after SUM keeps the calculation transparent and avoids rounding every segment separately; if the purpose instead requires each segment to be rounded on its own, calculate those row-level results first and sum those results deliberately.

How to Choose

Start by deciding what the rounded value is meant to represent. Use a positive number of digits for decimal precision, zero for a whole-number result, and a negative number when you want to round to tens, hundreds, or another power of ten. For a nonstandard increment such as five minutes or five centimeters, divide by that increment, round the quotient to zero digits, and multiply by the increment again.

Next, decide whether rounding away from zero is actually appropriate. ROUNDUP is intentionally conservative for positive quantities that must cover a requirement, such as the number of containers needed, but it is not the same as Excel’s ROUND function, which rounds to the nearest value. For negative inputs, ROUNDUP moves farther from zero; test a negative example if your data can include negative values so that the direction is clear to anyone using the workbook.

Finally, identify whether you are rounding source values or a calculation based on them. Rounding each row before adding or averaging can change the result compared with calculating first and rounding once at the end. Keep source data intact, put the rounded result in a separate column, and label the units and precision so another reader can tell whether a displayed 10 represents an exact value or a rounded-up total. Cell formatting can change how many decimal places appear on screen, but it does not replace a ROUNDUP formula or alter the stored value.

Frequently Asked Questions

What is the difference between ROUNDUP and ROUND?
ROUNDUP always increases a number’s magnitude to the requested precision. ROUND rounds to the nearest value, so it can move either up or down depending on the following digit.

Does ROUNDUP always make a number larger?
No. It moves away from zero: positive values become larger, while negative values become more negative. A value already at the requested precision stays unchanged.

What does a negative number of digits mean?
It rounds to the left of the decimal point. For example, -1 means tens and -2 means hundreds; the result still moves away from zero.

Can I use ROUNDUP to get the next multiple of a number?
Yes. Divide the value by the desired increment, round the quotient to zero decimal places, then multiply by the increment. An exact multiple remains unchanged rather than advancing to a strictly larger multiple.

Why does changing a cell’s number format not do the same thing?
Formatting controls what Excel displays, not the underlying calculation. ROUNDUP changes the formula’s returned value, which can affect later calculations and comparisons.

Final Thoughts

ROUNDUP is most useful when a result must not fall short of a positive requirement, or when a consistent precision or increment is needed. Choose the digits argument carefully, account for negative values, and be explicit about whether the formula rounds inputs, averages, or totals. Keeping the original data beside the rounded result makes the workbook easier to verify and reuse.

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.