When you are dealing with financial spreadsheets, tax calculations, or complex division, you often end up with numbers that look like this: 145.892374.
The most common way people deal with this is by using the “Decrease Decimal” button on the Home ribbon. They click the button twice, the number magically shrinks to 145.89, and everything looks great on the screen.
However, this is a dangerous trap. The “Decrease Decimal” button is just a visual mask. It hides the extra numbers from your eyes, but Excel’s internal calculator still sees 145.892374. If you use that cell in another formula, Excel will use the full, hidden number, which can cause your final totals to be off by a few cents (or a few thousand dollars).
If you want to permanently and mathematically alter the number so the extra decimals no longer exist, you must use the ROUND function.
Understanding the Syntax
The ROUND function requires exactly two arguments to work.
Syntax: =ROUND(number, num_digits)
- number: The actual number you want to change, or the cell reference containing the number (e.g., A2).
- num_digits: Exactly how many decimal places you want to keep.
Example 1: Rounding to Standard Currency
If you have a messy sales calculation in cell A2 that equals $45.1289, you want to round it to two decimal places so it looks like normal money.
The Formula:
=ROUND(A2, 2)
Excel looks at the third decimal digit (the 8). Because 8 is five or higher, Excel rounds the previous number up. The final, mathematically pure result becomes 45.13. All the extra hidden decimals are permanently destroyed.
Example 2: Rounding to Whole Numbers
If you are calculating inventory, you cannot sell 14.7 boxes of paper. You need to round to the nearest whole, solid number.
To do this, you simply tell the ROUND function to keep zero decimal places.
The Formula:
=ROUND(14.7, 0)
The result will be 15.
Advanced Trick: Rounding to Tens or Hundreds
Most people don’t realize that the num_digits argument can actually accept negative numbers. Instead of rounding decimals on the right side of the dot, a negative number forces Excel to round whole numbers on the left side of the dot.
This is incredibly useful for creating high-level summary reports where you want clean, rounded estimates rather than exact figures.
- Round to the nearest Ten: Use
-1.
=ROUND(1,452, -1)will result in 1,450. - Round to the nearest Hundred: Use
-2.
=ROUND(1,452, -2)will result in 1,500. - Round to the nearest Thousand: Use
-3.
=ROUND(1,452, -3)will result in 1,000.
Alternatives: ROUNDUP and ROUNDDOWN
The standard ROUND function follows standard mathematical rules (1-4 rounds down, 5-9 rounds up).
If you want to force Excel to always round in a specific direction regardless of the mathematical rules, you can swap the formula for its two sister functions:
=ROUNDUP(3.1, 0)will force the number up to 4.=ROUNDDOWN(3.9, 0)will force the number down to 3.