Provide rounding tool that sums correctly

We use a column of numbers and divide each one by the total to see the % each
one should be allocated in other formulas. The sum total should add to 100%
and it does in the sum cell. However, when using for other purposes, the
column does not add up. It appears the system retains the numbers to an Nth
decimal that do add; when displaying less decimals, a rounded number, they do
not add to the total. When using a rounded number for further calculations,
the answer is off also.

See

http://www.mcgimpsey.com/excel/pennyoff.html

for an explanation

--
Regards,

Peo Sjoblom


"travnman@discussions.microsoft.com"
<travnman@discussions.microsoft.com@discussions.microsoft.com> wrote in
message news:1C3581DE-DDBD-4E02-8053-9652233597EE@microsoft.com...
> We use a column of numbers and divide each one by the total to see the %
> each
> one should be allocated in other formulas. The sum total should add to
> 100%
> and it does in the sum cell. However, when using for other purposes, the
> column does not add up. It appears the system retains the numbers to an
> Nth
> decimal that do add; when displaying less decimals, a rounded number, they
> do
> not add to the total. When using a rounded number for further
> calculations,
> the answer is off also.

Hi

It depends on how precise your breakdown needs to be.
One way (which is simple, but not precisely accurate) is to calculate all
the figures except the final one. This final figure is calculated by taking
the total of the others from 100%

--
Andy.


"travnman@discussions.microsoft.com"
<travnman@discussions.microsoft.com@discussions.microsoft.com> wrote in
message news:1C3581DE-DDBD-4E02-8053-9652233597EE@microsoft.com...
> We use a column of numbers and divide each one by the total to see the %
> each
> one should be allocated in other formulas. The sum total should add to
> 100%
> and it does in the sum cell. However, when using for other purposes, the
> column does not add up. It appears the system retains the numbers to an
> Nth
> decimal that do add; when displaying less decimals, a rounded number, they
> do
> not add to the total. When using a rounded number for further
> calculations,
> the answer is off also.