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


"
crosoft.com wrote in
message ...
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.


"
crosoft.com wrote in
message ...
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.