Knowledge base KB0028

Rounding errors

Problem

It is a known mathematical problem that the total of rounded values does not necessarily equal the rounded total of the precise values.

For example, even when percentage values entered in the datasheet accumulate to 100%, rounded values in the chart may be slightly off, if a different number of decimal places is chosen.

Solution

think-cell's Excel data rounding feature (see Excel data rounding) ensures that all numbers are rounded consistently, and precisely add up to the rounded total. This feature is particularly convenient if you also use think-cell's Excel data links (see Excel data links) to create PowerPoint charts from the rounded data.

Share

think-cell uses cookies to improve the functionality, performance and security of this site. Your consent is necessary if you want to use the full functionality of this site. More information on the use of cookies by think-cell, your consent and your privacy rights can be found in our privacy policy.