How to Round in Microsoft Excel: Formulas and Tips

Formulas & functions · Updated November 20, 2026

To round a number in Excel, use ROUND in a formula: if the value is in A2 and you want two decimal places, enter =ROUND(A2,2) in another cell. Use ROUNDUP or ROUNDDOWN when you need to control the direction. These formulas change the calculated result; changing the number format only changes how the value looks.

This guide is for Microsoft Excel for Microsoft 365 on Windows. You will need a workbook with the numbers you want to round and an empty cell or column for the results. The same functions are available in Excel for Mac and Excel for the web, though ribbon layouts can vary slightly.

What You’ll Need

  • An Excel workbook containing numbers, such as prices, measurements, or percentages.
  • An empty column or another destination cell for formula results, unless you only want to change how many decimal places are displayed.
  • A decision about the rounding rule: nearest value, always up, always down, or nearest multiple such as 5 or 0.25.

Step-by-Step

  1. Identify what should be rounded. Find the source cell or range and decide how many decimal places the result should contain. For example, two decimal places are common for currency display, while a whole number may be appropriate for a count. Check whether you need a true rounded result or only a tidier display: a formula changes the value used in later calculations, but formatting leaves the stored value unchanged.

  2. Choose a destination cell. If your original numbers are in column A, put the result in B2 rather than replacing A2 immediately. Keeping the original values makes it easier to check the result and change the rounding rule later. Add a column label such as Rounded value in B1 so other people can tell what the new numbers represent.

  3. Enter ROUND for ordinary rounding. With the original number in A2, enter =ROUND(A2,2) in B2 to round to two decimal places. Excel rounds a following digit of 5 or greater away from zero at that decimal place, and a following digit below 5 toward zero. For example, if A2 contains 12.345, the result is 12.35; if A2 contains 12.341, the result is 12.34. The second argument tells Excel how many places to keep.

  4. Set the number of places deliberately. With the value in A2, use =ROUND(A2,0) to round to the nearest whole number. A positive second argument keeps decimal places: 2 means hundredths and 1 means tenths. A second argument of 0 means no decimal places. A negative argument rounds to the left of the decimal point: with A2 holding 1,276, =ROUND(A2,-1) returns 1,280, while =ROUND(A2,-2) returns 1,300. Negative places are useful for estimates or figures reported to the nearest ten or hundred.

  5. Use ROUNDUP or ROUNDDOWN if direction matters. With the number to round in A2, enter =ROUNDUP(A2,2) to round away from zero to two decimal places, or =ROUNDDOWN(A2,2) to round toward zero. For a positive value such as 4.231, these return 4.24 and 4.23 respectively. The words “up” and “down” refer to movement away from or toward zero, not simply to a larger or smaller displayed number. That distinction matters for negative values: rounding away from zero makes a negative number more negative.

  6. Round to a multiple when decimal places are not the goal. With a value in A2, use =MROUND(A2,0.25) to round to the nearest quarter. If A2 contains 2.62, the result is 2.5 because it is nearer to 2.5 than to 2.75. Replace 0.25 with another interval, such as 5, when the result should land on multiples of five. The number and the multiple should have the same sign; otherwise MROUND returns an error. At an exact midpoint, MROUND rounds away from zero.

  7. Fill the formula down the column. After entering the formula in B2, select B2 and drag its small square fill handle at the lower-right corner down alongside your data. You can also copy B2, select the cells below it, and paste. Excel adjusts the relative reference for each row, so the next row uses A3, then A4, and so on. Check the first and last results to confirm the filled range lines up with the source numbers.

  8. Keep the rounded results, if needed. If another system or calculation must receive the rounded numbers as fixed values, select the result cells and copy them. Then use Home > Paste > Paste Values, or right-click and choose the Values paste option. This replaces the formulas in the destination with their current results. Keep the original source column or a backup copy if you may need the unrounded data later.

  9. Use number formatting for appearance only. Select the cells, then on the Home tab use the Increase Decimal or Decrease Decimal buttons in the Number group. For more control, open Home > Number and choose a format, or press Ctrl+1 on Windows to open Format Cells. On Mac, Control+1 opens Format Cells in Excel; the Number controls are also on the Home tab. Formatting a value such as 12.345 to show two decimals displays 12.35, but calculations still use the underlying 12.345.

Common Mistakes

Confusing displayed digits with rounded data. Reducing visible decimal places does not change the stored number. If the value is only being shown on a report, formatting may be all you need. If later calculations must use a rounded value, create a formula with ROUND or the appropriate directional function.

Choosing the wrong direction. ROUND is nearest, not always down. ROUNDUP and ROUNDDOWN have specific directions relative to zero, so test them with both positive and negative sample values if the data can include negatives. Do not assume “up” always means a numerically larger answer.

Using the wrong second argument. A positive number means decimal places, zero means a whole number, and a negative number means places to the left of the decimal. Entering 2 when you intended -2 produces a very different result. Check the sign as well as the digit.

Rounding repeatedly. Applying rounding at several stages can produce a different total from rounding once at the end. For example, rounding line items before adding them may not match adding the original amounts and then rounding the total. Choose the point in the calculation where rounding is required and use that approach consistently.

Overwriting original data too soon. Replacing a source column with rounded numbers makes it difficult to recover the original precision. Use a separate results column first, verify it, and only paste values over the source if you have a safe copy and that replacement is intentional.

Tips

  • Use a clear heading such as Rounded to 2 decimals or Nearest 5. A label makes the rule visible when someone reviews the workbook later.

  • Format formula results to match the intended output. A formula can return a rounded value while Excel still displays extra decimal places if the result cell has a different number format.

  • Test a few boundary cases, especially values ending in 4, 5, or 6 at the place being rounded. Also check a negative value if your data includes one.

  • For percentages, remember that the stored value may be a decimal: 0.126 formatted as a percentage appears as 12.6%. Decide whether you are rounding the underlying decimal or simply choosing how many percentage decimal places to show.

  • Excel may use a semicolon instead of a comma between formula arguments in some regional settings. If a formula with commas is rejected, check the argument separator expected by your Excel installation; the function and its arguments remain the same.

  • Keep formulas in a separate column until you have checked their results. This makes it straightforward to compare the original and rounded numbers side by side and spot an incorrect range or rounding rule.

Troubleshooting

The formula appears as text instead of calculating. The cell may be formatted as Text, or the entry may begin with an apostrophe. Change the cell format to General using Home > Number, then edit the entry and press Enter again. Confirm that the formula starts with an equals sign and that the cell is not set to display formulas instead of results.

You see a name or syntax error. Check that the function name is spelled correctly, the parentheses are balanced, and the argument separator matches your regional settings. If your Excel expects semicolons, replace the commas between arguments with semicolons. Also make sure the referenced cell contains a number rather than text that only looks like a number.

MROUND returns an error. Check whether the value and the multiple have opposite signs. MROUND requires them to have the same sign. Also verify that the multiple is a valid number, not a text entry or an empty reference.

The answer looks unchanged or has unexpected digits. Confirm the number of places you supplied, including whether it should be negative. Then inspect the result cell’s number format: formatting can add or hide displayed digits without changing the formula result. Clicking the result cell and checking the formula bar can help distinguish the stored result from its display.

The total does not match a calculator or another report. Check whether the other calculation rounds each item before adding, or rounds only the final total. Also verify that the source values have not already been rounded or imported with limited precision. Make the rounding stage consistent before comparing totals.

Frequently Asked Questions

How do I round to two decimal places in Excel?
Put the original value in one cell and enter a ROUND formula in another, using 2 as the number of digits. The result is rounded to hundredths; apply a two-decimal number format too if you want trailing zeros, such as 3.50, to remain visible.

How do I round to the nearest whole number?
Use ROUND with 0 decimal places. Excel applies its ordinary nearest-value rule, so a digit of 5 at the first decimal position rounds away from zero.

What is the difference between ROUND and formatting decimal places?
ROUND produces a new calculated value that later formulas can use. Formatting changes only the displayed appearance, leaving the stored value intact. Choose based on whether your calculation needs the rounded value or only a shorter display.

How do I always round down?
Use ROUNDDOWN with the desired number of digits. It moves toward zero, which means a negative number becomes less negative. If you need a specific multiple rather than a number of decimal places, choose a suitable multiple-rounding approach instead.

Can Excel round to the nearest 10 or 100?
Yes. Use ROUND with -1 for the nearest ten or -2 for the nearest hundred. Negative digit counts round to the left of the decimal point, while positive counts round to the right.

Can I round a whole column at once?
Enter the formula beside the first value, then fill it down alongside the remaining rows. Check that the last formula refers to the matching source row. If you need fixed numbers rather than formulas, copy the results and paste values after checking them.

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.