Why Excel Shows Rounding Errors and How to Round Calculations
Question details
Understand why Excel produces small differences in calculations and how to round results to a specified number of decimal places.

- 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.
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.
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.
Click the cell containing the addition or subtraction formula.
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.
Press Enter and check the result. If another formula uses this cell, it will use the rounded result.

Format Excel cells to display two decimal places
Use number formatting when you only need a cleaner display and do not need to change the calculated value.
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. Open the workbook: Launch WPS Office, open Spreadsheets, and select Open to choose your workbook.
- 2. Select a result cell: Click the cell where you want the rounded calculation to appear.
- 3. Enter the ROUND formula: Type =ROUND(A1-B1,2), replacing the cell references and calculation as needed, then press Enter.
- 4. Save the workbook: Choose File > Save or Save As and select the workbook format you need.

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.




