Excel Formula for Rounding Numbers: ROUND and More

Formulas & functions · Updated November 18, 2026

Use Excel’s ROUND function to round a number to a chosen number of decimal places: with the value in A2, enter =ROUND(A2,2) to round it to two decimal places. For other needs, ROUNDUP always rounds away from zero, ROUNDDOWN rounds toward zero, and formatting can change how a number looks without changing its stored value.

How the ROUND formula works

ROUND takes two arguments: the number to round and the number of digits to keep. The first can be a cell reference or a calculation; the second controls the rounding position. Excel examines the digit immediately to the right of that position. If it is 5 or greater, the kept digit increases by one; if it is less than 5, the kept digit stays as it is.

With the number 12.345 in A2, enter =ROUND(A2,2). The result is 12.35: Excel keeps two decimal places and rounds the third decimal digit, 5, up. The value in A2 remains unchanged; the formula returns a rounded result in the cell where you enter it.

For a basic workflow:

  1. Put the number you want to round in a cell, such as A2.
  2. Select the cell where you want the rounded result to appear.
  3. Type a formula that references the number and specifies the desired digit position.
  4. Press Enter. To apply the same calculation to more rows, copy or fill the formula down.

Using a reference rather than typing a number directly makes the result update when the source value changes. If you need a fixed rounded value rather than a formula, you can later copy the result and use Paste Special to paste values; keep the original data if you may need its full precision.

What the second argument means

The second argument, often called num_digits, sets the place at which Excel rounds. A positive value means decimal places to the right of the decimal point. Zero means the nearest whole number. A negative value rounds to the left of the decimal point, so it can round to tens, hundreds, or larger place values.

  • Positive digits: 1 keeps one decimal place, 2 keeps two, and 3 keeps three.
  • Zero: rounds to the nearest integer.
  • Negative digits: -1 rounds to the nearest ten, -2 to the nearest hundred, and -3 to the nearest thousand.

With 148.5 in A2, =ROUND(A2,0) returns 149. The half value rounds away from zero. With 1,267.89 in A2, =ROUND(A2,-2) returns 1,300, the nearest hundred. Negative digits can be useful for estimates or summarized counts, but they deliberately discard detail, so choose the place value that suits the task.

The number of decimal places displayed in a cell does not determine the second argument. A cell might display 12.3 while storing 12.345; rounding that underlying value to two places returns 12.35. If you want to round the value itself, use a rounding function rather than relying only on the display setting.

ROUND, ROUNDUP, and ROUNDDOWN compared

These three functions differ in how they handle digits beyond the chosen position. ROUND uses the nearest result. ROUNDUP moves away from zero, while ROUNDDOWN moves toward zero. That distinction matters for negative values: “up” does not simply mean a larger number on the number line.

With 3.141 in A2, =ROUNDUP(A2,2) returns 3.15, while =ROUNDDOWN(A2,2) returns 3.14. The first moves away from zero and the second toward zero. With -3.141 in A2, =ROUNDUP(A2,2) returns -3.15, which is farther from zero; =ROUNDDOWN(A2,2) returns -3.14, which is closer to zero.

Choose among them based on the rule you need:

  • Use ROUND for ordinary rounding to the nearest decimal or place value.
  • Use ROUNDUP when the result must never be closer to zero than the input at the chosen precision.
  • Use ROUNDDOWN when you must discard extra digits without increasing the magnitude.

These functions are not interchangeable in a chain of calculations. Rounding each line item first can produce a different total from adding full-precision values and rounding only the final total. Decide which stage should be rounded based on the applicable business, reporting, or measurement rule, rather than assuming Excel will choose it for you.

Rounding to a multiple instead of decimal places

Sometimes the target is a multiple such as 5, 10, or 0.25, rather than a fixed number of decimal places. MROUND rounds to the nearest multiple. For a value in A2 and a multiple in B2, =MROUND(A2,B2) uses B2 as the interval. For example, if A2 contains 17.6 and B2 contains 5, the result is 20, the nearest multiple of 5.

For a directional result, CEILING.MATH rounds up to a multiple and FLOOR.MATH rounds down to a multiple. With 12.2 in A2 and 5 in B2, =CEILING.MATH(A2,B2) returns 15, while =FLOOR.MATH(A2,B2) returns 10. These functions are useful for grouping values into intervals, setting quantities in fixed increments, or rounding a measurement to a chosen step.

Be clear about what “up” means in a particular task. The rules for negative numbers and optional arguments can affect whether the result moves toward or away from zero. If negative inputs are possible, test representative positive and negative values before filling a formula across a dataset. Also check that the multiple is appropriate and nonzero for the intended calculation.

Rounding versus changing number format

Excel offers two different ways to show fewer decimal places. The Home tab’s Number group includes controls to increase or decrease displayed decimal places. Those controls change the cell’s number format: they alter what appears on screen, but generally leave the underlying value available to calculations. By contrast, a function such as ROUND returns a rounded number that subsequent formulas can use.

For example, suppose A2 contains 7.846. If you set A2 to display two decimal places, it appears as 7.85, but a formula that uses A2 can still use 7.846. With A2 containing 7.846, =ROUND(A2,2) returns a value of 7.85. The visual result may look identical, but the formula result has been rounded for later calculations.

Choose formatting when the goal is simply a cleaner presentation, such as showing a column of measurements to two decimal places while retaining the original precision. Choose a rounding formula when the rounded value itself must feed a later calculation, export, or report. Avoid assuming that a cell’s visible digits tell you exactly what is stored; inspect the formula bar or the underlying formula when a result seems unexpected.

INT, TRUNC, and other related choices

INT and TRUNC can look like rounding tools, but they do not follow the same nearest-value rule as ROUND. INT rounds a number down to the next integer, meaning toward negative infinity. TRUNC removes the fractional part and moves toward zero. For positive numbers, both may appear to simply drop decimals, but negative numbers reveal the difference.

With -3.2 in A2, =INT(A2) returns -4, while =TRUNC(A2) returns -3. Neither returns -3 as ordinary nearest-integer rounding would for -3.2; to round to the nearest integer, use ROUND with zero decimal places. Select these functions only when their specific behavior—flooring or truncating—is what the calculation requires.

As a practical rule, use ROUND for nearest-value rounding, ROUNDUP or ROUNDDOWN for directional decimal-place rounding, MROUND for the nearest specified interval, and INT or TRUNC when you need an integer result under their distinct rules. A function name that sounds intuitive is not a substitute for checking how it handles negative values.

Common rounding problems and how to avoid them

A common surprise is that a result such as 2.675 may not behave exactly as a person expects when rounded to two decimal places. Computers store many decimal fractions using binary floating-point representations, so some decimal values cannot be represented with perfect precision internally. Excel’s displayed values and calculations can therefore expose tiny differences in the stored number. This is not necessarily a sign that the formula is malformed.

When a result is unexpectedly close to a rounding boundary, check the source value at more decimal places and review the formula feeding it. The value may already contain extra digits from an earlier calculation or import. If the rule requires rounding at an intermediate stage, apply the appropriate function at that stage; formatting the source cell to hide digits does not impose that rule.

Other useful checks include:

  • Confirm the second argument: 2 means two decimal places, while -2 means the nearest hundred.
  • Check whether the requirement is nearest, always up, always down, or to a particular multiple.
  • Test negative inputs if the data can include them; directional rounding behaves relative to zero.
  • Check whether you are adding original values or rounded results. The two approaches can yield different totals.
  • Keep the original data when rounding is for presentation or when later review may require the unrounded numbers.

For a column, enter the formula in the first result row and fill it down. Verify several rows—including boundary cases and negative values if applicable—before relying on the full column. If the numbers come from another system, check whether that system has already rounded or formatted them during export.

Frequently Asked Questions

What is the basic Excel formula for rounding to two decimal places?
Use ROUND with the number’s cell reference and 2 as the second argument. For a value in A2, =ROUND(A2,2) returns the nearest value to two decimal places.

How do I round to the nearest whole number in Excel?
Set the number of digits to zero. For a number in A2, =ROUND(A2,0) returns the nearest integer, with midpoint values rounded away from zero.

How do I round to the nearest 10 or 100?
Use a negative number for the second argument of ROUND. For example, -1 rounds to the nearest ten and -2 to the nearest hundred. Use MROUND instead when the desired interval is a multiple that is not a power of ten.

Does decreasing decimal places change the actual number?
No. Decreasing displayed decimal places with the number-format controls changes how the cell appears, not usually the stored value. A rounding formula returns a rounded result that can be used in subsequent calculations.

Why does ROUNDUP make a negative number more negative?
ROUNDUP moves away from zero. For a negative number, moving farther from zero means a smaller value on the number line. If you instead need to move toward zero, use ROUNDDOWN.

Choosing the right method

For most everyday cases, start with ROUND and set the digit position explicitly. Use a format change when you only want a shorter display, and use a different function when a requirement specifies a direction or a fixed multiple. Those choices keep the spreadsheet’s visible presentation, stored precision, and calculation rules distinct.

Before applying a rounding rule to a full workbook, verify it with a few known examples: a value below a midpoint, one above it, a midpoint, and—where relevant—a negative value. That small check can reveal whether the formula matches the intended rule and prevent a subtle difference from being repeated across many rows.

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.