Calculation Issues

Why Excel Shows Rounding Errors and How to Round Calculations

Steve KSteve K Nov 20, 2026 869 views

Question details

Understand why Excel produces small differences in calculations and how to round results to a specified number of decimal places.

Why Excel Shows Rounding Errors and How to Round Calculations
Product
Microsoft Excel
Device & OS
not provided
Scenario
Adding or subtracting values that appear to have two decimal places.
Observed behavior
Excel may return results such as 0.0100000000000193 or 530.879999999999 instead of the expected two-decimal values.
Before you start

Select the cells involved and check their formulas and displayed decimal places. Values that appear rounded may contain additional digits, and decimal fractions cannot always be represented exactly in binary.

Solution 1Recommended

Use ROUND to calculate a fixed-decimal result in Excel

Use ROUND when the calculated value itself needs to be rounded, such as to two decimal places.

Excel uses binary floating-point arithmetic, so some decimal values cannot be represented exactly. Small differences can appear in the result even when the input cells look rounded.

1
Select the result cell

Click the cell containing the addition or subtraction formula.

2
Wrap the calculation in ROUND

In the formula bar, change the formula to use ROUND. For example, enter =ROUND(A1-B1,2) to round the difference to two decimal places.

3
Apply and check the result

Press Enter and check the result. If another formula uses this cell, it will use the rounded result.

Use ROUND to calculate a fixed-decimal result in Excel
Round at the appropriate stage: Rounding each intermediate calculation can produce a different final result than rounding only the total. Choose the approach that matches your calculation requirements.
Calculate with WPS Spreadsheets

Round spreadsheet calculations with WPS Office

Open a workbook in WPS Spreadsheets and use ROUND to calculate results to the decimal places you need.

  1. 1. Open the workbook: Launch WPS Office, open Spreadsheets, and select Open to choose your workbook.
  2. 2. Select a result cell: Click the cell where you want the rounded calculation to appear.
  3. 3. Enter the ROUND formula: Type =ROUND(A1-B1,2), replacing the cell references and calculation as needed, then press Enter.
  4. 4. Save the workbook: Choose File > Save or Save As and select the workbook format you need.
Round addition and subtraction results with familiar formulasOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formatting controlsWork with spreadsheets using a free office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show extra digits after a subtraction?

Excel stores and calculates numbers using binary floating-point arithmetic. Some decimal fractions cannot be represented exactly, which can lead to small differences in a result.

How do I round an Excel formula to two decimal places?

Wrap the calculation in ROUND with 2 as the second argument. For example, enter =ROUND(A1-B1,2) in the result cell.

Does displaying two decimal places change the value used in formulas?

No. Changing decimal places in the Home tab's Number group changes the display, not the underlying value. Use ROUND to change the calculated result.

Can I use ROUND in WPS Spreadsheets?

Yes. Open your workbook in WPS Spreadsheets and enter a formula such as =ROUND(A1-B1,2) in a result cell.