Round Up in Excel: Use ROUNDUP for Any Number or Decimal

To round a value in Excel away from zero, use =ROUNDUP(A2,0) when the number is in cell A2 and you want a whole number. Change the final argument to choose decimal places: 2 keeps two decimal places, while -1 rounds to tens. ROUNDUP works on the underlying value, not just how it looks on screen, and it rounds negative numbers away from zero too.

This guide is for Microsoft Excel for Microsoft 365 on Windows. You can use the same formulas in Excel for Mac and Excel for the web. Before you begin, decide how many decimal places or what place value you need, since rounding to a whole number is different from rounding to cents or to the nearest ten.

What You’ll Need

An Excel workbook with the values you want to round.
A blank column or cells where you can put the rounded results, if you want to keep the original values unchanged.
The number of decimal places or place value you want, such as two decimal places or the nearest ten.

Step-by-Step

Choose where the result should go. For example, if your original values are in column A, starting at A2, click B2 to keep the rounded result beside the original. Using a separate result column is usually safer than replacing the source values: you can compare the two, revise the rounding rule, or use the original data later.
Enter the ROUNDUP formula. With the original number in A2 and the result going in B2, type =ROUNDUP(A2,0) in B2 and press Enter. The zero tells Excel to round to zero decimal places, or to a whole number. For example, if A2 contains 4.12, the result is 5; if it contains 4.00, the result remains 4. ROUNDUP does not add one to a value that is already exactly on the requested place.
Set decimal places when you need them. With the value in A2 and the answer in B2, use =ROUNDUP(A2,2) to round to two decimal places. If A2 is 6.271, the result is 6.28. Use 1 for one decimal place, 3 for three, and so on. This can be useful for quantities that need a fixed decimal precision. Remember that ROUNDUP moves away from zero, so a value such as 6.270 stays 6.27 rather than becoming 6.28.
Use a negative digit count to round to tens or hundreds. With the original value in A2 and the result in B2, enter =ROUNDUP(A2,-1) to round away from zero to the nearest ten. For 126.3, the result is 130. To round to the nearest hundred, use =ROUNDUP(A2,-2); 126.3 becomes 200. A negative digit count removes places to the left of the decimal point, while a positive count sets places to the right.
Copy the formula down the column. With the first formula in B2 and more values in A3, A4, and the rows below, select B2 and drag the small fill handle at the lower-right corner down the rows you need. Excel adjusts the references for each row, so the next cell refers to A3, then A4, and so on. You can also select B2 and the cells below it, then choose Home > Fill > Down. On Windows, Ctrl+D fills down; on Mac, use Command+D.
Check the results and use them where needed. Compare a few outputs against their source values, including values that are already exact and values with several decimal places. If you need the rounded values in another calculation, refer to the result cells in that calculation. Keep the original column if you may need the unrounded measurements later.

The key idea is that ROUNDUP’s second argument controls the place where rounding happens. A zero means a whole number; a positive number means decimal places; a negative number means places to the left of the decimal. The function rounds any remaining fraction away from zero at that place.

Common Mistakes

Confusing rounding up with rounding to the nearest value. ROUNDUP always moves away from zero when there is a remainder. It does not use the usual halfway rule that rounds some values down and others up. For example, with A2 containing 2.11 and B2 as the result cell, =ROUNDUP(A2,1) returns 2.2, even though the decimal part is less than 0.05. For conventional nearest-value rounding, use Excel’s ROUND function instead.
Expecting negative numbers to move toward positive infinity. ROUNDUP means away from zero, not always toward a larger number. With -2.11 in A2, the formula =ROUNDUP(A2,1) returns -2.2, which is smaller numerically. If by round up you mean the mathematical ceiling, where -2.11 becomes -2.1 at one decimal place, use a ceiling function instead and check its behavior for your chosen significance.
Using the wrong digit count. A positive digit count rounds to decimal places, zero rounds to an integer, and a negative digit count rounds to tens, hundreds, or larger place values. Entering 2 when you meant -2 gives a very different result. Check the sign as well as the number.
Changing the displayed decimals instead of rounding the value. The Increase Decimal and Decrease Decimal buttons on the Home tab change how many digits are displayed. They do not necessarily change the underlying number. If later calculations must use a rounded value, use ROUNDUP in a formula, then base later calculations on its result.
Overwriting source data too soon. Pasting rounded results over the original numbers can make it impossible to recover the exact inputs. Keep a copy of the source column or save a separate workbook before replacing data.

Tips

Use cell references for repeatable work. Referring to A2 makes the formula easy to fill down and lets you update the source number without editing the formula. Typing a fixed number into each formula is harder to maintain.
Round before a later calculation only when that is the intended rule. A displayed value of 12.30 may still contain more digits internally. If your process requires each line item to be rounded before it is added, calculate ROUNDUP for each line first and sum those results. If it requires rounding only the final total, add the unrounded values first and round the total. Those approaches can produce different answers.
Be explicit about negative values. If your data can include credits, temperature changes, or other negatives, test a positive and a negative sample before applying the formula to a large range. ROUNDUP’s away-from-zero behavior may not match a business rule that means the next higher number.
Use a number format after calculating, if needed. The result can be shown with a fixed number of decimal places without changing the calculation. Select the result cells and use the Number group on the Home tab to choose a number format. Treat formatting as presentation; the ROUNDUP formula determines the value.
Keep formula arguments clear. In the standard English-language Excel setup, formula arguments are separated by commas. Some regional settings use semicolons instead. If Excel flags a correctly structured formula as invalid, check the list separator used by your installation rather than changing the rounding logic.

Troubleshooting

The result looks unchanged. Check whether the source number is already exact at the chosen place. For instance, rounding 8.5 to a whole number with ROUNDUP still gives 9, but rounding 8.00 to a whole number gives 8. Also check the formula bar: the cell may display fewer digits than its stored value, or a number format may hide the difference.
The result rounds in the wrong direction for a negative value. This is usually expected: ROUNDUP moves away from zero. If you need the mathematical ceiling instead, use CEILING.MATH. With -2.11 in A2 and the result in B2, =CEILING.MATH(A2,0.1) returns -2.1. Test the formula on representative negative values, since the significance you choose determines the multiples to which Excel rounds.
Excel shows a formula error. Confirm that the function is spelled ROUNDUP and that the formula starts with an equals sign. Check that parentheses are balanced and that the argument separator matches your regional settings. Excel for Microsoft 365 supports ROUNDUP; the function is not specific to a newer release.
The formula appears as text instead of calculating. Select the cell and check Home > Number Format. If it is set to Text, change it to General, then edit the cell and press Enter again. Also check whether Show Formulas is enabled; on Windows, Ctrl+` toggles that view, and the Mac shortcut can vary by keyboard layout. The formula bar is another way to see whether Excel recognizes the entry as a formula.
Only the first row changes when you copy the formula. Make sure you filled the formula down rather than copying only the displayed value. Click a lower result cell and inspect its formula bar; its reference should point to the matching row in the source column. If you used dollar signs in a reference, those may have locked the row. Remove them when you want the reference to adjust as the formula is filled down.

Frequently Asked Questions

Does ROUNDUP always increase a number? No. It rounds away from zero. Positive values generally become larger when a fraction is removed, while negative values become more negative. Exact values at the selected place remain unchanged.

How do I round up to two decimal places? With the original value in A2 and the result in B2, use =ROUNDUP(A2,2). For example, 3.141 becomes 3.15. If the value is already 3.140, the result is 3.14.

How do I round up to the nearest whole number? With the source value in A2 and the answer in B2, use =ROUNDUP(A2,0). This gives 5 for 4.01 and 4 for 4.00. The formula rounds away from zero, including for negative inputs.

Can I round up to the nearest ten? Yes. With the number in A2 and the result in B2, use =ROUNDUP(A2,-1). For example, 121 becomes 130. Use -2 for hundreds and -3 for thousands.

Does ROUNDUP change the original cell? No. A formula in another cell returns a rounded result while leaving the source alone. If you replace source values with results, do so only after confirming that you no longer need the original precision.

Is ROUNDUP the same as changing decimal places in the ribbon? No. ROUNDUP calculates a new rounded value. Number formatting changes what Excel displays, but calculations can still use the full underlying value. Choose based on whether you need a genuinely rounded result or only a different display.

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.