Always have cells add up to 100
I have range of cells that are the same right now, and they add up to
100:
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
100
I would like to be able to change on of those values, and the others
adjust to still add up to 100. Any ideas?
|