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 22.1 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 21. Excel data links) to create PowerPoint charts from the rounded data.

Share