View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff[_53_] Jeff[_53_] is offline
external usenet poster
 
Posts: 1
Default 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?