Let's assume we have 4 continuous cell in column C: C2,C3,C4, and C5.
The sum of all 4 cells must equal a number, let's say 100.
As the user inputs the first number in any of the cells, the other cells automically populate by equally dividing teh difference between 100 and the the cell where a was entered.
Here are two examples which will make these easy to see:
The user enters 25 into C3, 100-25=75. There are 3 remaining blank cells, so (75/3) 25 would be populated in
the open cells.
Let's say, the user enters 50 into C3, and 10 into C5, (100 - 50 - 10 = 40), 40 / 2 = 20, 20 woudl be entered in to the cells C2 and C4.
make sense?
Thanks for reading!
Bookmarks