Excel Formula to Round to the Nearest Whole Number

To round a number in Excel to the nearest whole number, use the ROUND function with zero decimal places. If the value is in cell A2, enter =ROUND(A2,0); for example, 4.7 becomes 5 and 4.2 becomes 4. The formula returns a rounded result without changing the original value in A2.

How the ROUND formula works

ROUND takes two arguments: the number to round and the number of decimal places to keep. Setting the second argument to 0 tells Excel to round to the nearest integer. You can use a cell reference, a calculation, or a typed number as the first argument, as long as it is a value Excel can evaluate as a number.

With a value in A2, the formula =ROUND(A2,0) returns a whole-number result in the cell where you enter it. To use it, select an empty cell, type the formula, and press Enter. The result will update if the value in A2 changes. To apply the same calculation to other rows, drag or copy the formula down; Excel adjusts the relative cell reference for each row.

The zero is important. A positive second argument keeps digits to the right of the decimal point, while a negative one rounds to the left of it. For example, rounding to the nearest ten uses a different number of digits than rounding to the nearest whole number. For the question “nearest whole number,” use zero.

Examples with positive numbers and halfway values

For ordinary positive values, Excel rounds down when the fractional part is less than one-half and up when it is one-half or greater. Assuming the number is in A2, these examples show the results:

With 8.3 in A2, =ROUND(A2,0) returns 8.
With 8.5 in A2, =ROUND(A2,0) returns 9.
With 8.9 in A2, =ROUND(A2,0) returns 9.
With 0.49 in A2, =ROUND(A2,0) returns 0.

A value ending in exactly .5 is a midpoint: it is equally far from the whole numbers on either side. Excel’s ROUND function resolves that tie by rounding away from zero. That means 2.5 rounds to 3, rather than 2. If A2 contains 2.5, =ROUND(A2,0) returns 3. The same midpoint rule matters for negative values, where rounding away from zero means moving to the more negative integer.

In a worksheet, a displayed value may look like a midpoint even when its stored value is slightly above or below it. This can happen when a number comes from a calculation or a data import. If a result seems surprising, inspect more decimal places in the source cell before assuming the rounding function is behaving inconsistently.

Rounding negative numbers

Negative numbers often expose a misunderstanding about “up” and “down.” For nearest-integer rounding, Excel applies the same nearest-value rule and rounds exact halfway values away from zero. With -2.4 in A2, =ROUND(A2,0) returns -2 because -2 is nearer. With -2.5 in A2, =ROUND(A2,0) returns -3 because -3 is the result of rounding the midpoint away from zero.

This is not the same as always moving toward a larger number on the number line. For instance, -2 is larger than -3, but Excel rounds -2.5 to -3. It is also not the same as always rounding toward positive infinity. Knowing the midpoint rule is particularly useful when a column contains credits, temperature changes, measurements below zero, or other negative values.

Enter the formula and fill it down a column

To round a list while preserving its original values, put the results in a separate column. For example, if raw numbers are in A2:A20, select B2 and enter =ROUND(A2,0). Press Enter, then copy or fill the formula down through B20. Each row will show the rounded version of the corresponding value in column A.

A practical workflow is:

Keep the original numbers in one column so you can refer back to them.
Enter the rounding formula in the first result row, using the matching source cell.
Check a few results, including a value below .5, one above .5, and a midpoint if one is present.
Fill the formula down to the remaining rows.
Use the rounded-results column in later calculations when rounded values, rather than the raw values, are intended.

Formula results are dynamic: changing a source number recalculates the result. If you need fixed numbers instead, you can copy the result cells and use Paste Values to replace formulas with their current results. Keep a copy of the original data first, especially when the rounded values will be used in a report or shared workbook.

Rounding a value is different from changing its display

Excel can show a number with zero decimal places without actually rounding the stored value. For example, formatting 6.8 to display no decimal places may make the cell appear as 7, but the underlying value can still be 6.8. A formula that later adds or compares that cell uses the stored value, not the appearance on the screen.

Use number formatting when you only want a cleaner display and need to retain the original precision. Use ROUND when a later calculation should use the rounded value. This distinction can affect totals: a column of values may display as whole numbers while its total is calculated from the unrounded decimals. If the business rule says each line must be rounded before being added, calculate rounded values in a helper column and total that column. If the rule says to add precise values and round only the final total, round the total instead. These approaches can produce different answers.

ROUND, ROUNDUP, ROUNDDOWN, INT, and TRUNC

Choose the function based on the rule you need, not merely on how many digits should appear. ROUND chooses the nearest value. ROUNDUP always rounds away from zero, and ROUNDDOWN always rounds toward zero. With 3.2 in A2, =ROUNDUP(A2,0) returns 4, while =ROUNDDOWN(A2,0) returns 3. With -3.2 in A2, those functions return -4 and -3 respectively.

INT rounds a number down to the nearest integer, meaning toward negative infinity. With -3.2 in A2, =INT(A2) returns -4. TRUNC removes the fractional part and moves toward zero; with -3.2 in A2, =TRUNC(A2) returns -3. For positive values these two functions can look similar, but for negative values their difference is important. Neither is a substitute for nearest-integer rounding in all cases.

For a standard “closest whole number” result, use ROUND. Choose a directional function only when a rule explicitly requires always rounding in that direction—for example, a count that must never understate a requirement may need a different treatment than an ordinary nearest-value estimate.

Round to a multiple instead of a whole number

Sometimes “round to a whole number” is not the actual requirement. A price might need to be rounded to the nearest 0.05, or a measurement to the nearest 5 units. Excel’s MROUND rounds to a specified multiple. With 13.2 in A2, =MROUND(A2,5) returns 15, the nearest multiple of 5. With 12 in A2, the same formula returns 10. For the nearest integer, the multiple is 1, but ROUND is the simpler and more direct choice.

Be precise about the intended increment. Rounding to the nearest 0.25 is different from rounding to two decimal places: two decimal places keep hundredths, while a multiple of 0.25 produces quarter-unit steps. The choice depends on the measurement or reporting rule, not on how many digits the cell displays.

Common problems and checks

If Excel shows an error or the output does not match expectations, check the input and the formula before changing the rounding rule. A number imported from another system may be stored as text, and text that looks numeric may not behave like a number in a calculation. Check that the source cell contains a numeric value, and examine its formatting or convert the data where appropriate.

Wrong number of digits: For nearest whole numbers, the second argument must be 0, not 1 or -1.
Only the display changed: Number formatting does not necessarily alter the value used in calculations; use a rounding formula if the value itself must be rounded.
Unexpected negative result: Remember that midpoint rounding is away from zero, and distinguish INT from TRUNC.
Formula does not calculate: Confirm that the source is numeric and that the formula begins with an equals sign. If Excel displays the formula as text, the cell may be formatted as Text; change the format and re-enter the formula.
Argument separator differs: The examples use commas, as in =ROUND(A2,0). Excel may use semicolons in some regional settings, depending on the system’s list-separator configuration.

Dates and times also deserve care. Excel stores dates as serial numbers and times as fractions of a day. Rounding a date serial to a whole number can change the date, while rounding a time to a whole number can reduce it to a day boundary. If your goal is to show a date without a time, or a time to the nearest minute, use an appropriate date/time format or a calculation designed for that unit rather than blindly rounding the serial value to zero decimal places.

Frequently Asked Questions

What is the Excel formula to round to the nearest whole number?
With the value in A2, enter =ROUND(A2,0). The zero specifies that no decimal places should remain.

Does Excel round 2.5 up or down?
With 2.5 in A2, =ROUND(A2,0) returns 3. Excel rounds exact halfway values away from zero, so -2.5 rounds to -3.

How do I round a whole column in Excel?
If the source values are in A2:A20, put =ROUND(A2,0) in B2, then fill or copy the formula down to B20. The original values remain in column A.

How do I round without a formula?
You can format cells to display zero decimal places, but that changes only the display, not necessarily the stored values. Use a formula when later calculations must use rounded results.

What is the difference between ROUND and ROUNDUP?
ROUND chooses the nearest value, while ROUNDUP always moves away from zero. For example, with 3.2 in A2, =ROUND(A2,0) returns 3 and =ROUNDUP(A2,0) returns 4.

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.