chrissbrady
Feb 2, 2009, 02:13 PM
I am having the problem of keeping my percentages adding up to 100%. If I have 10 columns with 10% a piece, the sum is 100%. If I then change the first column to 1%, is there any way for the rest of the columns to be automatically updated to 11% a piece?
e.g..
10 10 10 10 10 10 10 10 10 10 =total (100)
change the first column to 1%
1 11 11 11 11 11 11 11 11 11 =total (100)
and the rest of the columns automatically update to 11%, equally redistributing the 9% from the first column.
Thanks
e.g..
10 10 10 10 10 10 10 10 10 10 =total (100)
change the first column to 1%
1 11 11 11 11 11 11 11 11 11 =total (100)
and the rest of the columns automatically update to 11%, equally redistributing the 9% from the first column.
Thanks