AI Excel Generator
← ALL GUIDES

How to Round Numbers to the Nearest Whole Number in Excel

Updated November 4, 2026 · AI Excel Generator

To round a number to the nearest whole number in Excel, use the ROUND function with the number of decimal places set to zero.

The midpoint rule and the sign of a value can affect the result, so a few examples help prevent surprises.

Use ROUND to Round to the Nearest Whole Number

Excel’s ROUND function rounds a value to a specified number of digits.

For whole numbers, set the second argument to 0:

=ROUND(A2,0)

If cell A2 contains 12.6, the formula returns 13.

If A2 contains 12.4, it returns 12.

The formula changes the calculated result; it does not merely hide decimal places through cell formatting.

You can also enter a number directly: =ROUND(18.75,0) returns 19.

In a worksheet, a cell reference is usually more practical because the result updates when the source value changes.

How Excel Handles Halfway Values

When the first discarded digit is 5 or greater, ROUND moves the value away from zero.

When that digit is 4 or lower, it rounds toward zero.

For positive values, this matches the familiar rule of rounding 5 up.

  • =ROUND(6.5,0) returns 7.
  • =ROUND(6.49,0) returns 6.
  • =ROUND(-6.5,0) returns -7.
  • =ROUND(-6.49,0) returns -6.

Excel’s rule for negative halfway values can differ from expectations based on rounding toward positive infinity.

For example, rounding -6.5 away from zero produces -7, not -6.

Round a Range in a New Column

To round a list of values without replacing the original data, enter a formula in the first result row and fill it down.

For values in A2:A6, put this in B2:

=ROUND(A2,0)

Then copy or fill the formula through B6.

Excel adjusts each row reference, so B3 uses A3 and B6 uses A6.

For example, if A2:A6 contain 2.3, 2.5, 7.8, -1.5, and 10, the rounded results are 2, 3, 8, -2, and 10.

If the source value is produced by another calculation, you can wrap that calculation in ROUND.

For instance, =ROUND(A2/B2,0) rounds the quotient to a whole number.

Use this when downstream calculations should use the rounded result, rather than only display fewer decimal places.

Choose the Right Rounding Function

ROUND is appropriate when values should go to the nearest integer.

Other functions serve different rules:

  • ROUNDUP(A2,0) rounds away from zero.

    For example, ROUNDUP(4.1,0) returns 5, while ROUNDUP(-4.1,0) returns -5.
  • ROUNDDOWN(A2,0) rounds toward zero.

    For example, ROUNDDOWN(4.9,0) returns 4, and ROUNDDOWN(-4.9,0) returns -4.
  • INT(A2) rounds down to the next integer, meaning toward negative infinity.

    Thus, INT(4.9) returns 4, but INT(-4.1) returns -5.
  • TRUNC(A2) removes the fractional part, which is equivalent to rounding toward zero when no digit argument is supplied.

These distinctions matter for negative values.

If a business rule says “always round up” or “drop the decimals,” confirm what that means for negative amounts before choosing a formula.

Round to a Multiple Instead of an Integer

To round to the nearest multiple, use MROUND.

For the value in A2, =MROUND(A2,5) rounds to the nearest multiple of 5.

If A2 is 17, the result is 15; if it is 18, the result is 20.

This is useful for package sizes, time blocks, or pricing increments.

For whole-number rounding, =ROUND(A2,0) is clearer.

MROUND requires the number and multiple to have compatible signs; mismatched signs can return an error.

Check the function’s behavior for midpoint values when a specific tie rule is required.

Rounding a Display Is Different from Rounding a Value

Changing the number format to show zero decimal places can make 12.6 appear as 13, while the cell still stores 12.6.

Calculations that reference that cell generally continue using the stored value.

By contrast, =ROUND(A2,0) returns a rounded value that can be used in later formulas.

Use number formatting when you only want a cleaner display, such as showing whole-dollar amounts in a report.

Use ROUND when the calculation itself must use an integer, such as rounding a calculated unit count before adding it to another result.

Common Issues and Compatibility

ROUND is a standard worksheet function in modern desktop Excel, Excel for the web, and Google Sheets.

The formula syntax shown here works in those spreadsheet applications.

Regional settings may use a semicolon instead of a comma between arguments, so a localized installation may require =ROUND(A2;0).

  • The result looks unchanged: If A2 contains a whole number already, rounding it to zero decimal places leaves it unchanged.
  • A formula returns an error: Check that the referenced cell contains a numeric value.

    Numbers stored as text may need conversion before rounding.
  • Displayed and calculated values differ: A cell format can hide decimals without changing the underlying value.

    Inspect the formula bar or use ROUND if later calculations must use the integer.
  • Unexpected midpoint behavior: Check whether the value is positive or negative and whether it is exactly halfway.

    ROUND sends halfway values away from zero.

For predictable results, keep the original data in one column, place the rounding formula in another, and label the rounded output clearly.

This makes it easier to audit which values were rounded and to adjust the rounding rule later.