think-cell round – Always correct
How to solve the problem of Excel data rounding
When data is compiled for a report or PowerPoint presentation rounding summations in Excel is a frequent problem. It is often desirable but difficult to achieve that rounded totals match the total of the rounded addends. think-cell round solves this problem in an automated and easy-to-use way.
|Videos||A good starting point for understanding how think-cell round actually works is to watch it in action. Therefore, we have created some short videos covering its main benefits.|
|Documentation||After watching our videos for a first impression of think-cell round our online documentation is the right place to look for in-depth feature information.|
If you are not yet aware of the problems arising when rounding Excel data, please have a look at the following examples.
|1.5 + 2.6 + 3.6 = 7.7|
When rounding all numbers to the nearest integer, you get the following. Totals that appear to be "miscalculated" are in bold.
|2 + 3 + 4 = 8|
For some, this is the most desirable outcome, because each number is as close to the unrounded number as possible. In the simple example the largest deviation is 0.5, from 1.5 to 2. You can achieve this result in Excel by using "Format Cell" on each value.
But some people object, because the arithmetic is not correct. They propose to add up the rounded values. Totals that deviate from the original value by 1 or more are in bold.
|2 + 3 + 4 = 9|
You can do this in Excel by using =ROUND(x,0) on the addends. The problem is that now in the simple example the largest deviation, from 7.7 to 9, is 1.3, much larger than before.
Is there some middle-ground between correct rounding and correct arithmetic? Yes, there is, because you can round as rendered by the following table. "Tuned" values are in bold.
|1 + 3 + 4 = 8|
The sum adds up and in the simple example the maximum deviation is now 0.5, from 1.5 to 1. Rounding in such a way is trivial in this case, but becomes very complicated if you sum over larger two- or even three-dimensional tables. This process is what think-cell round automates.
Using think-cell round, you can achieve consistently rounded totals with minimal "tuning": While most values are rounded to the nearest integer, a few values are rounded in the opposite direction, thus maintaining correct calculations without accumulating rounding error.
Since there are many possibilities to achieve correctly rounded totals by changing values, the software picks a solution that requires the minimum number of values changed and the minimum deviation from the precise values.
Benefits of using think-cell round
think-cell round is just as easy to use as any other Excel function. Plus, its toolbar allows quick and easy access to its calculation power for several cells at a time.
Stop rounding numbers on the whiteboard. This add-in will relieve you of hours of boring work.
Simply apply think-cell round to your problem and see how it solves it in seconds, or control the rounding decision on a cell-by-cell basis using the other functions of think-cell round.