Excel ROUND: Does It Round Positive or Negative Numbers?

Excel’s ROUND function rounds both positive and negative numbers to the nearest value at the specified decimal place. When the digit being removed is exactly 5, Excel rounds away from zero: 2.5 becomes 3, while -2.5 becomes -3.

What Excel ROUND does

ROUND changes a number’s precision according to the number of digits you ask it to keep. It works the same way whether the input is above or below zero; the sign is retained, and the magnitude is rounded to the nearest place. In Microsoft Excel for Microsoft 365 on Windows, enter the function in a cell and press Enter. You can also fill the formula down a column to apply it to other values.

For a simple whole-number example, assume A2 contains 2.5. Enter =ROUND(A2,0) in B2; the result is 3. The second argument, 0, means round to zero decimal places, or to the nearest integer. If A2 instead contains -2.5, the same formula returns -3.

For a decimal example, assume A2 contains 6.284. Enter =ROUND(A2,2) in B2; the result is 6.28, because the third decimal digit is 4. If A2 contains 6.285, the result is 6.29: the digit after the hundredths place is 5, so the hundredths digit increases. This same tie rule applies to negative inputs, away from zero.

How Excel rounds positive and negative numbers

For values that are not exact halfway cases, ROUND chooses the nearest result. With a positive input, rounding up generally increases its magnitude; with a negative input, rounding up in magnitude makes it more negative. This is why the result of rounding -2.5 to a whole number is -3 rather than -2. “Away from zero” describes the direction at an exact tie, not a rule that every negative value always becomes more negative.

For instance, with -2.4 in A2, =ROUND(A2,0) in B2 returns -2, the nearer integer. With -2.6 in A2, that same formula returns -3. The halfway example, -2.5, is equally distant from -2 and -3, so Excel resolves the tie away from zero and returns -3.

This can differ from descriptions of rounding that say “5 rounds up.” That phrase can be confusing for negative values because “up” may mean toward positive infinity, which would make -2.5 become -2. Excel’s ROUND tie rule is not that: it rounds away from zero, making -2.5 become -3. If matching Excel results matters, use that precise description.

What a negative num_digits value means

The second argument can be positive, zero, or negative. A positive value specifies decimal places to retain; zero specifies the nearest whole number; and a negative value specifies places to the left of the decimal point. Thus, -1 rounds to the nearest ten, -2 to the nearest hundred, and -3 to the nearest thousand. A negative num_digits does not make the result negative; the sign of the original number remains.

Assume A2 contains 1,267. With =ROUND(A2,-2) in B2, Excel returns 1,300, the nearest hundred. With -1,267 in A2 and the same formula in B2, Excel returns -1,300. The midpoint cases follow the tie rule: with 1,250 in A2, =ROUND(A2,-2) in B2 returns 1,300; with -1,250 in A2, it returns -1,300.

Rounding to the nearest hundred is a calculation, not just a way to shorten what appears on screen. The returned number is 1,300, and later calculations use that rounded result. If you want to keep the original exact value for calculations but show fewer digits, number formatting is usually more appropriate.

Choosing the right rounding function

Use ROUND when you want the nearest value. If you specifically need a direction instead, Excel has functions that make the choice explicit. With 1.21 in A2, enter =ROUNDUP(A2,1) in B2; the result is 1.3. With -1.21 in A2, the same formula returns -1.3. ROUNDUP moves away from zero, regardless of the input sign.

ROUNDDOWN moves toward zero rather than always toward a smaller numerical value. With -1.29 in A2, enter =ROUNDDOWN(A2,1) in B2; the result is -1.2. With 1.29 in A2 and the same formula, the result is 1.2. This distinction matters: for a negative number, moving toward zero makes the numerical value larger, even though its absolute size is smaller.

Pick the function based on the rule you need:

Choose ROUND for the nearest decimal place, whole number, ten, hundred, or other place.
Choose ROUNDUP when the result must move away from zero, such as when a policy requires any partial unit to count as a full unit.
Choose ROUNDDOWN when the result must move toward zero.
Use a number format when the goal is only to change how many digits are displayed, not the underlying value.

Rounding to a multiple instead of a digit place

Sometimes “round to the nearest” means a particular increment, such as the nearest 0.05, 5, or 25, rather than a decimal place. MROUND rounds to a multiple. For example, with 17 in A2, enter =MROUND(A2,5) in B2; the result is 15, the nearest multiple of 5. With 18 in A2, the same formula returns 20. At an exact tie, the result is rounded away from zero.

MROUND is not interchangeable with ROUND: the second argument is the multiple, not the number of decimal places. Also, the number and multiple generally need to have the same sign; using opposite signs can produce a #NUM! error. If you need an increment-based rule with deliberate behavior for negative numbers, check the function’s sign requirements and test representative values before applying it to a full dataset.

Calculated rounding versus displayed decimals

Changing the number format alters the display but does not, by itself, replace the stored value. Suppose A2 contains 12.3456. If you format it to display two decimal places, Excel may show 12.35, while calculations can still use 12.3456. By contrast, with A2 containing 12.3456 and =ROUND(A2,2) in B2, B2 contains a rounded result of 12.35.

This difference can explain why a total does not seem to match the sum of the rounded figures shown in a report. If each line must be rounded before adding, round each line and total those rounded results. If only the final total should be rounded, add the original values first and round the total. Those are different calculation rules and can produce different answers.

Excel also has a workbook option called “Set precision as displayed.” It changes stored values to match their displayed precision, which can permanently discard digits from the workbook’s calculations. It is not a harmless display setting. Use ROUND in formulas when you need an explicit, auditable rounding step; avoid changing workbook precision casually, and make a copy before changing calculation settings.

Common problems and misconceptions

A frequent mistake is treating negative num_digits as a request for a negative answer. It only tells Excel which place to round to. For example, a positive number rounded to the nearest thousand can remain positive, while a negative number rounded to the nearest thousand remains negative.

Another source of confusion is the difference between rounding and truncating. ROUND selects the nearest value and can go either direction. ROUNDDOWN discards the specified lower-order digits by moving toward zero. Neither should be confused with mathematical floor, which always moves toward negative infinity: for example, the floor of -1.2 is -2, not -1.2. When a business rule says “always round down,” clarify whether it means toward zero or toward negative infinity before selecting a function.

Decimal calculations can also involve binary floating-point representation. Some decimal fractions cannot be represented exactly in binary, so a displayed value that looks like a precise midpoint may be stored internally as a value slightly above or below it. If a result surprises you, inspect the underlying value, test a simpler input, and verify whether the rule should apply to the stored value or a rounded decimal amount. Do not assume that changing the cell’s display format changes the calculation.

Frequently Asked Questions

Does Excel ROUND negative numbers up or down?
At an exact halfway point, Excel rounds away from zero: -2.5 rounds to -3. For other values, it rounds to the nearest result; for example, -2.4 rounds to -2 and -2.6 rounds to -3.

Does ROUND(-2.5,0) return -2 or -3?
It returns -3. Excel’s ROUND function resolves halfway cases away from zero, so a negative tie becomes more negative.

What does ROUND(number,-2) do in Excel?
It rounds the number to the nearest hundred. For example, with 1,267 in A2, =ROUND(A2,-2) returns 1,300; with -1,267 in A2, it returns -1,300.

How do I round a number up in Excel?
Use ROUNDUP when “up” means away from zero. It moves positive and negative values away from zero; it does not mean always toward positive infinity. If the rule means something else, choose a function that matches that direction.

Does formatting a cell round the actual value?
No. Ordinary number formatting changes the displayed digits while retaining the underlying value for calculations. Use ROUND in a formula when later calculations must use the rounded result.

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.