How to check for rounding deviations?
What does "Rounding deviations" mean?
The calculated value in this cell is different from the value you would get if you perform the calculation with the displayed values.
Why is it important?
​As long as you only work in Excel, rounding deviations are typically not a problem. However, this info becomes relevant if you copy values from Excel to another application, e.g., PowerPoint, where only the displayed values are shown (e.g., when displaying the values on a chart).
Example:
In the table below, "Net income" is the sum of EBT and Tax expenses. When you calculate 66,861.0 + (-21,395.5) the result in the purple cell would be 45,465.5 and not 45,465.4. However, the difference stems from rounding to the first decimal place. The value is correct when adding the actual values.
To avoid any confusion and prevent issues when using the data in, e.g. PowerPoint, we highlight this cell and give a description in our Add-in:
How do I fix the issue?
Check if the referenced cells and the rounded sum are used outside Excel. If this is not the case, this problem likely does not need to be fixed. If it is used outside Excel, increase the number of decimal places to be copied to a tool outside Excel.
In addition, check if the cell with the rounding deviation is correctly linked in the workbook e.g. with our Dependents feature to avoid subsequent mistakes.