Calculation Issues

How to Fix Excel Floating-Point Calculation and Rounding Errors

Maira Mehtab Sep 22, 2026 869 views

Question details

The user is experiencing floating-point precision issues where calculated numbers display long decimal strings instead of expected rounded numbers.

Product: Excel
Device & OS: not provided
Scenario: Performing calculations that are converted to text or evaluated within intermediate expressions, resulting in unintended microscopic decimal discrepancies.
Observed behavior: Excel displays results with tiny precision discrepancies, such as showing 0.289999999999999 instead of the exact value of 0.29.

Before you start

If you plan to use global precision settings rather than individual formulas, save a backup copy of your workbook first, as modifying precision settings will permanently change your stored values.

Solution 1Recommended

Use the ROUND Function in Formulas

Wrap your calculations in the ROUND function to explicitly set the desired number of decimal places, preventing floating-point anomalies when converting to text.

Select the target cell

Click on the cell where you want the calculated result to appear.

Enter the ROUND formula

Type your formula using the ROUND syntax. For example, instead of =A1-B1, type =ROUND(A1-B1, 2) to round the result to two decimal places.

Convert to text (Optional)

If you are converting the result into a text string, wrap it inside a text function or concatenate it after rounding, such as =CONCAT("Result: ", ROUND(A1-B1, 2)).

Apply the formula

Press Enter to execute the calculation. The value will now accurately display exactly to the specified decimals without floating-point trailing digits.

Solution 2

Enable 'Set Precision as Displayed'

Change Excel's advanced options to force the workbook to use the displayed value for calculations, resolving rounding discrepancies globally.

Professional Spreadsheet Software

Handle Complex Calculations Easily with WPS Office

WPS Office offers powerful calculation tools and a familiar interface that handles complex formulas, floating-point math, and rounding seamlessly. It provides native support for all standard spreadsheet functions while ensuring peak performance.

1. Open your spreadsheet: Launch WPS Spreadsheets and open the workbook containing your data.
2. Select the formula cell: Click on the cell where you want to perform the calculation.
3. Apply the ROUND function: Type =ROUND(your_calculation, number_of_digits) to ensure your results are free of floating-point errors, then press Enter.

Fully compatible with Microsoft Excel (.xlsx) formatsNative support for all standard mathematical and rounding functions like ROUND, ROUNDUP, and ROUNDDOWNLightweight architecture ensures fast performance even with large datasetsFree to use with a familiar, easy-to-learn interface that requires no retraining

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show 0.289999999999999 instead of 0.29?

Spreadsheet programs use the IEEE 754 standard to store and calculate floating-point numbers in binary format. Because many decimal fractions cannot be represented exactly in binary, minor precision errors inevitably occur during internal calculations.

Does formatting a cell to two decimal places fix the floating-point error?

No. Formatting a cell only changes how the number looks on the screen. The underlying floating-point value remains unchanged, which can still cause calculation issues if that cell is referenced in other formulas or converted into text.

What is the difference between the ROUND function and Set Precision as Displayed?

The ROUND function corrects precision on a formula-by-formula basis without altering your original raw data. 'Set precision as displayed' permanently changes all the underlying data in the entire workbook to exactly match its visual formatting, which permanently deletes any hidden decimal accuracy.

Excel & Data Problems