1. Excel incorrectly calculated - correct cells selected?
The most common Problem why Excel is incorrectly attributed, is, that the wrong cells are selected. Therefore, check whether you have included the correct cells in the formula.
- With "=SUM (A3;A4;A5)" just add the three cells A3 + A4 + A5.
- With "=SUM(A3:A50)" add all values of column A from cell 3 to cell 50.
- With "=SUM(A3:F3)" are added all the values of row 3 from A to F.
2. Excel incorrectly calculated rounding error
The bigger Problem, the power of Excel is often in the Addition are due to rounding. The individual values result in a different sum as Excel has calculated. Excel rounds first, each individual value from the 15. Body and adds the rounded values then. As a result, a significant rounding error occurs in the sum.
- Open the tab "formulas". There you will find the "calculation".
- From there you can select "settings" and then select "calculation options".
- There is a new dialog window opens where you can enable the option "precision as displayed" setting. Important: If you enable the Option, all of the specified decimal places. You should be more specific decimal digits are not entered, they will be neglected.
- Don't forget to confirm with OK. Thus, the Problem of the rounding should be fixed.
By the way: you can in Excel, times add.
