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 when a different number of decimal places is chosen.

Solution

think-cell's Excel data rounding feature ensures that all numbers are rounded consistently, and precisely add up to the rounded total. Using the data rounding feature to prepare a presentation is particularly convenient if you also use think-cell's Excel data link feature to create PowerPoint charts from the rounded data.