Adding Percent Columns

[Patricia]

Is there a way to calculate a percent of a total and have
the column automatically add up to 100% ? Often times the
column will add up to a bit more or less due to rounding...

 

[J.E. McGimpsey]

One way:


A50: =100%

The only other way is if you adjust your other cells to collect the
rounding error. Eg:

A1: =1
A2: =ROUND(A1/7,4) ==> 14.29%
A3: =ROUND(A1/7,4) ==> 14.29%
....
A8: =ROUND(A1/7,4) ==> 14.29%
A9: =SUM(A2:A8) ==> 100.03%

If instead you used:

A8: =A1-SUM(A2:A7) ==> 14.26%
A9: =SUM(A2:A8) ==> 100.00%

but you'll have to decide how much deviation is acceptable. - you
may need to break it up across different cells, or multiple cells.