Excel ROUND Function: Examples, Rules, and Common Errors

Formulas & functions · Updated November 22, 2026

To round a number in Excel, use ROUND: with 12.345 in cell A2, enter =ROUND(A2,2) in another cell to get 12.35. The second argument tells Excel how many decimal places to keep; use 0 to round to a whole number or a negative number to round to tens, hundreds, or larger place values.

A basic ROUND example

Suppose a worksheet has a measurement of 12.345 in A2 and you want to show it to two decimal places. Enter this formula in B2:

With 12.345 in A2, enter =ROUND(A2,2) in B2. The result is 12.35.

The formula returns a rounded numeric value, not just a shorter-looking version of the value in A2. A2 remains 12.345; B2 contains the rounded result. You can replace A2 with a number typed directly into the formula, but referencing a cell makes a worksheet easier to update and audit.

For example, a list of measurements in A2:A20 can be rounded row by row by entering =ROUND(A2,2) in B2 and filling the formula down. Excel adjusts the reference for each row, so the next formula uses A3, then A4, and so on. In Microsoft 365 for Windows, drag the fill handle at the lower-right corner of B2 down the column, or copy the cell and paste it into the destination range.

ROUND syntax and its arguments

The function has two required arguments: ROUND(number, num_digits). The number argument is the value or cell reference to round. The num_digits argument is an integer that specifies the place to which Excel rounds. In a worksheet where A2 contains 12.345, use =ROUND(A2,2) to keep two decimal places; it returns 12.35.

The number of digits works in both directions from the decimal point:

  • A positive num_digits rounds to that many decimal places. In a sheet with 12.345 in A2, =ROUND(A2,1) returns 12.3.
  • Zero rounds to the nearest whole number. With 12.6 in A2, =ROUND(A2,0) returns 13.
  • A negative num_digits rounds to the left of the decimal point. With 1,234 in A2, =ROUND(A2,-2) returns 1,200.

For negative num_digits, -1 means the nearest ten, -2 the nearest hundred, and -3 the nearest thousand. If the value is smaller than the rounding place, the result can be zero. For instance, in a sheet with 42 in A2, =ROUND(A2,-2) returns 0 because 42 is closer to zero than to 100.

How Excel decides which way to round

ROUND looks at the digit immediately beyond the requested place. If that digit is 0 through 4, the retained digit stays the same; if it is 5 through 9, the retained digit increases by one in magnitude. For example, with 8.234 in A2, =ROUND(A2,2) returns 8.23, while with 8.235 in A2 the same formula returns 8.24.

At a midpoint, Excel rounds away from zero. This detail matters for negative values: with -8.235 in A2, =ROUND(A2,2) returns -8.24, not -8.23. For a whole-number midpoint, with 2.5 in A2, =ROUND(A2,0) returns 3; with -2.5 in A2, the result is -3. This rule differs from some conventions that round midpoint values to the nearest even digit, so do not assume all software or published standards use the same tie-breaking method.

Excel stores numbers using binary floating-point representation. Some decimal fractions cannot be represented exactly in binary, which can matter when a calculated value is extremely close to a rounding midpoint. If an unexpected result occurs, inspect the underlying value at more decimal places and check the preceding calculations, rather than relying only on what the cell displays.

Round to whole numbers, tens, or custom places

Choose num_digits based on the place you need, not on how many digits the original number contains. With 6,482.73 in A2, =ROUND(A2,0) returns 6,483, =ROUND(A2,-1) returns 6,480, and =ROUND(A2,-3) returns 6,000. These are different numerical results, each useful for a different purpose.

ROUND does not directly mean “round to the nearest multiple of five” or “nearest quarter.” For that kind of interval, Excel has MROUND. For example, with 17.2 in A2, =MROUND(A2,5) returns 15, the nearest multiple of five. MROUND rounds midpoint cases away from zero as well. Check that the number and significance have the same sign; using opposite signs can produce an error.

For a fixed step such as 0.25, MROUND can round to a quarter-unit interval. With 3.38 in A2, =MROUND(A2,0.25) returns 3.5. This differs from ROUND(A2,2), which keeps two decimal places and returns 3.38. The right function depends on whether the goal is a number of decimal places or a multiple of a particular interval.

ROUND versus changing the displayed decimal places

A frequent source of confusion is that a cell can look rounded without its stored value being rounded. The Home tab’s Number group includes Increase Decimal and Decrease Decimal controls. These change the number format: for example, a value of 12.345 may display as 12.35 when the cell is set to two decimal places, while the underlying value remains 12.345.

That difference affects later calculations. If a total should be calculated from values rounded to cents, formatting the original values to two decimals may not be enough: Excel can still use their extra stored decimal places in the calculation. Use ROUND in the calculation when the numeric result itself must be rounded. Conversely, if you only want a cleaner display and need to retain full precision for further analysis, formatting is often preferable.

To change display precision in Excel for Microsoft 365 on Windows, select the cells, then use Home > Number group > Increase Decimal or Decrease Decimal. The formula itself is the same in Excel for Mac and Excel for the web, although the ribbon layout can vary with the window size and platform. Formatting changes appearance; it does not replace the value with a rounded result.

ROUND, ROUNDUP, ROUNDDOWN, and TRUNC

ROUND chooses the nearest result at the specified place. ROUNDUP always rounds away from zero, while ROUNDDOWN always rounds toward zero. TRUNC removes digits beyond the specified place without rounding. These functions can produce different outcomes even when they use the same num_digits argument.

  • With 12.341 in A2, =ROUND(A2,2) returns 12.34; with 12.349 in A2, it returns 12.35.
  • With 12.341 in A2, =ROUNDUP(A2,2) returns 12.35 because it moves away from zero.
  • With 12.349 in A2, =ROUNDDOWN(A2,2) returns 12.34 because it moves toward zero.
  • With 12.349 in A2, =TRUNC(A2,2) returns 12.34 by removing the extra digits rather than rounding them.

For negative numbers, “up” and “down” can be misleading if interpreted as movement on a number line. ROUNDUP means away from zero: with -12.341 in A2, =ROUNDUP(A2,2) returns -12.35. ROUNDDOWN means toward zero: with the same value in A2, =ROUNDDOWN(A2,2) returns -12.34. If your requirement is ordinary rounding to the nearest value, use ROUND rather than choosing a function based on its name alone.

Common problems and useful checks

If Excel displays a formula as text instead of calculating it, check whether the cell is formatted as Text or whether the entry begins with an apostrophe. Change the cell format to General, then re-enter the formula. Also check that the formula starts with an equals sign and that the parentheses are balanced.

Excel argument separators depend on regional settings. The examples here use commas, as in =ROUND(A2,2). In a configuration that uses semicolons as list separators, Excel may require =ROUND(A2;2). If a comma-separated formula is rejected, use the separator configured for that installation; this does not change what the arguments mean.

Other checks can help identify a result that seems wrong:

  • Confirm num_digits: 2 means hundredths, while -2 means hundreds.
  • Look at the original value in the formula’s referenced cell, not only its formatted display.
  • Check whether a formula is rounding an intermediate result or only the final total. Those approaches can yield different totals.
  • Make sure the value is numeric. A number stored as text may not behave like a normal numeric cell reference.

Frequently Asked Questions

How do I round a number to two decimal places in Excel?
Put the value in A2, then enter =ROUND(A2,2) in another cell. For example, if A2 contains 5.678, the result is 5.68. Change 2 to the number of decimal places you want.

How do I round up in Excel?
Use ROUNDUP when every result must move away from zero. With 4.231 in A2, =ROUNDUP(A2,2) returns 4.24. For a result rounded to the nearest value rather than always upward in magnitude, use ROUND.

How do I round to the nearest 10 or 100?
Use a negative second argument. With 1,234 in A2, =ROUND(A2,-1) returns 1,230, while =ROUND(A2,-2) returns 1,200.

Why does my rounded cell still have extra decimal places in calculations?
It may only be formatted to display fewer places. Number formatting changes what you see, not the stored numeric value. Use ROUND in a formula if later calculations must use the rounded number.

Can ROUND work with negative numbers?
Yes. It rounds negative values to the nearest requested place, with midpoint cases away from zero. For example, with -2.5 in A2, =ROUND(A2,0) returns -3.

Does ROUND change the original cell?
No. A formula such as =ROUND(A2,2) returns its result in the cell containing the formula; it does not replace A2. To replace the original values, copy the rounded results and use Paste Special > Values, taking care to keep a backup if the original precision matters.

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.