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

You have not given us your consent to the use of cookies. You can change this decision in our privacy policy.