Round Excel Numbers to the Nearest Integer with Formulas

Formulas & functions · Updated November 18, 2026

To round a number to the nearest whole number in Excel, use the ROUND function with zero decimal places. If the value is in cell A2, enter =ROUND(A2,0); for example, a value of 8.6 returns 9, while 8.4 returns 8.

The quickest way to round in Excel

The basic formula is short: tell Excel which number to round, then specify zero digits after the decimal point. The result is a numeric value, not merely a number that looks like an integer. That distinction matters when you use the result in another calculation, sort a range, or export it to another system.

For a single value, replace A2 in the example with the cell that contains your number. For a column of values, enter the formula in a neighboring column and copy it down. If your value is typed directly into a formula instead of stored in a cell, the same function can round it: =ROUND(8.6,0) returns 9. In a reusable workbook, referring to a cell is usually easier to maintain because changing the input updates the result automatically.

Excel’s standard rounding rule sends values halfway between integers away from zero. Thus 2.5 becomes 3, and -2.5 becomes -3. This rule applies to the exact halfway case; values below or above the midpoint go to the nearer integer.

How ROUND works

ROUND takes two arguments: the number to change and the number of digits to keep. A second argument of 0 means round to an integer. A positive second argument keeps digits to the right of the decimal point, while a negative one rounds to the left of it.

  • Use 0 to round to the nearest whole number.
  • Use 1 to round to one decimal place, such as 4.26 to 4.3.
  • Use -1 to round to the nearest ten, such as 146 to 150.
  • Use -2 to round to the nearest hundred, such as 1,249 to 1,200.

For instance, if A2 contains 6.748, the formula =ROUND(A2,0) returns 7. If A2 contains -6.5, it returns -7. The decimal-place argument changes the place value being rounded; it does not mean the number of digits to remove. A negative argument is therefore useful for rounding larger quantities, not a way to request a negative result.

Rounding can also be applied inside a larger expression. If a calculation produces a decimal and you need the final result as a whole number, you can put the calculation inside ROUND. For clarity and easier checking, it is often simpler to calculate in one cell and round that result in another, especially in a workbook other people will review.

Round a cell or a whole column

To round one cell, select an empty cell where you want the answer, type the formula, and press Enter. If B2 contains the original value and you put the result in C2, use =ROUND(B2,0). The original value in B2 stays unchanged; only the result in C2 is rounded.

To apply the calculation to a list, put the formula beside the first value, then copy it down for the remaining rows. With source values in B2:B100 and the rounded output starting in C2, enter =ROUND(B2,0) in C2 and fill the formula through C100. Excel adjusts the cell reference in each row, so the formula in C3 refers to B3, and so on. Check the first and last few results to confirm the output lines up with the intended source rows.

If you need to replace the original values rather than create a separate result column, first calculate the rounded values in a helper column. Review them, copy the results, then use Paste Special > Values over the original range. This prevents accidental loss of the unrounded data before you have checked the outcome. Keep a copy of the original values if they may be needed for auditing or later calculations.

When different rows use different rules, the formula can refer to a cell containing the number of digits. For example, if A2 contains the value and B2 contains the desired decimal-place setting, use =ROUND(A2,B2) in C2. A value of 0 in B2 rounds to an integer; a value of -1 rounds to the nearest ten. This makes the rounding precision adjustable without editing the formula itself.

Choose the right rounding function

ROUND is the usual choice when the goal is the nearest integer. Other functions are useful when the rule is not ordinary nearest-value rounding. Before choosing one, decide whether you want the nearest result, a result always away from zero, or simply the decimal portion removed.

  • ROUND: chooses the nearest value at the requested place, with halfway values rounded away from zero. With A2 holding 12.5, =ROUND(A2,0) returns 13.
  • ROUNDUP: always rounds away from zero, even when the discarded fraction is small. With A2 holding 12.1, =ROUNDUP(A2,0) returns 13; with A2 holding -12.1, it returns -13.
  • ROUNDDOWN: always rounds toward zero. With A2 holding 12.9, =ROUNDDOWN(A2,0) returns 12; with A2 holding -12.9, it returns -12.
  • INT: rounds down to the next lower integer. With A2 holding -12.1, =INT(A2) returns -13, not -12.
  • TRUNC: removes the fractional part and moves toward zero. With A2 holding -12.9, =TRUNC(A2) returns -12.

The negative-number examples reveal why these functions are not interchangeable. For positive values, rounding down and truncating may appear to do the same thing. For negative values, INT moves toward negative infinity, while ROUNDDOWN and TRUNC move toward zero. If the business rule says always round down to a lower mathematical value, INT is different from a rule that says discard the decimal portion.

These examples assume the values described are in A2. If you use another input cell, replace A2 with that reference. There is no universally best function: the correct one depends on the rule your data or process requires. For an ordinary nearest-integer result, start with ROUND.

Rounding a value is not the same as changing its display

Excel can show a decimal value with no decimal places without changing the underlying number. Select the cells and use Home > Number > Decrease Decimal until no decimal digits are displayed, or press Ctrl+1 on Windows to open Format Cells, choose the Number category, and set Decimal places to 0. On Mac, Command+1 opens Format Cells. The exact visible ribbon layout can vary with the window size, but the Number group is on the Home tab.

Formatting is useful when you want a cleaner display but must preserve precision. A cell holding 3.7 can display as 4 while still retaining 3.7 for calculations. By contrast, a ROUND formula returns the rounded value in its result cell. If you need calculations to use the rounded whole number, use ROUND rather than relying on display formatting.

This difference can explain totals that look surprising. Suppose A2:A4 each contain 1.4 and are formatted to show zero decimal places. Each cell appears as 1, but the underlying values total 4.2. A SUM of those three cells returns 4.2, which may display as 4. If the requirement is to add three individually rounded values, first round each row and then total that rounded-results column. Decide which interpretation is intended before reporting the total.

Common problems and checks

A formula returning an unexpected integer is often following the requested rule correctly, while the rule or input is not what the user intended. Check the following points:

  • Check the midpoint rule. A value ending in exactly .5 rounds away from zero. Negative halfway values therefore move to the more negative integer.
  • Check the referenced cell. When copying a formula down, Excel normally adjusts relative references. Make sure the formula beside each result points to the corresponding source row, not a neighboring column or a header.
  • Check whether the cell contains a number. Imported data can look numeric but be stored as text. If the formula gives an error or does not behave as expected, inspect the source and convert text-formatted numbers to numbers before relying on the calculation.
  • Check the displayed value versus the stored value. A cell formatted with zero decimal places may hide a fraction. Widen the column or temporarily show decimal places to inspect the original data.
  • Check how totals should be calculated. Rounding each row before summing can produce a different total from summing exact values and rounding only once at the end.

Excel stores numbers with finite binary precision, so some decimal fractions cannot be represented exactly internally. As a result, a value created by earlier calculations may be extremely close to a midpoint rather than exactly on it. If a result surprises you, inspect more decimal places and review the calculations that produced the input. Do not add an arbitrary adjustment to every value without confirming the required rounding policy; that can make other results wrong.

Excel formulas normally use commas between arguments, as in the examples above. Some regional settings use semicolons in formulas instead. If Excel flags the comma-separated version as a syntax error, check the list separator used by your installation and follow its displayed convention.

Frequently Asked Questions

What is the formula to round a number to the nearest whole number in Excel?
If the number is in A2, use =ROUND(A2,0). The zero tells Excel to round to no decimal places, producing a whole-number result.

Does Excel round 2.5 up or down?
Excel’s ROUND function sends a halfway value away from zero. Therefore 2.5 rounds to 3, while -2.5 rounds to -3. This is not the same as always rounding toward positive infinity.

How do I round negative numbers to an integer?
Use ROUND with zero decimal places for the nearest integer. For example, if A2 contains -4.2, =ROUND(A2,0) returns -4; if A2 contains -4.5, it returns -5.

How do I round a number but keep the original value?
Put a ROUND formula in a different cell and point it at the original. The source stays unchanged, while the formula cell contains the rounded result. This is generally safer than overwriting the input.

Why does my rounded-looking cell still calculate with decimals?
The cell may only be formatted to display zero decimal places. Formatting changes appearance, not the stored value. Use a ROUND formula if later calculations must use the rounded number.

How can I round to the nearest ten instead of an integer?
Use a negative number of digits. If A2 contains 146, =ROUND(A2,-1) returns 150. Use -2 for the nearest hundred.

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.