Excel browser issue Calc_ROU_

Question

Why Excel on Average results via calculations not accurate =ROUND(,)

Moved from: Windows for home | Other | Apps

Answer 1

I finally found a solution_the F2_shown_the digital reference which solved the issue.

Answer 2

Excel uses IEEE 754 double‑precision floating‑point arithmetic, which can’t represent many decimal fractions (like 0.1) exactly. As a result, intermediate calculation results can contain tiny binary rounding errors (for example, a stored value might be 0.30000000000000004 instead of exactly 0.3). When such values are averaged or further calculated, the final result may look “not accurate” until rounded.

To improve accuracy of displayed results when using AVERAGE or other calculations, use one of these approaches:

1. Round inputs before averaging
   Example:
   =AVERAGE(ROUND(range, 2)) (entered as an array formula in non‑dynamic‑array Excel)
   This forces each value to a fixed number of decimal places before the average is computed.
2. Round the final result
   Example:
   =ROUND(AVERAGE(range), 2)
   This rounds the computed average to the number of decimal places needed.
3. Use “Set precision as displayed” (workbook‑wide, destructive)
   This forces stored values to match what is displayed, eliminating extra hidden decimals but permanently losing precision beyond the displayed digits:
   1. Select File > Options > Advanced.
   2. In When calculating this workbook, choose the workbook.
   3. Check Set precision as displayed.
   4. Save the workbook.
   Warning: any digits beyond the displayed precision are permanently lost and cannot be recovered. This affects all worksheets in the workbook.

The ROUND(number, num_digits) function itself works as documented: it rounds the given number to the specified number of digits (positive for decimals, zero for whole numbers, negative to round to tens, hundreds, thousands, etc.). If the inputs contain floating‑point artifacts, ROUND is the correct tool to normalize them to the precision required.

---

References:

• Floating-point arithmetic may give inaccurate results in Excel
• ROUND function
• Round a number to the decimal places I want in Excel