tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,832
- Office Version
- 365
- 2019
- Platform
- Windows
Imagine I have two cells A1 and A2, with values 30 and 70 and both are linked to two scrollbars.
If I increase the value of A1, A2 goes down, such that they always sum to 100. This has been done and works.
However, if I have 3 scrollbars, which also must sum to 100, (with initial values of 10, 20 and 70), is there a way such that when scrollbar one's value increases, (say from 10 to 11), that scrollbars 2 and 3 automatically decrease to 19.5 and 69.5, so that now 11+19.5+69.5 = 100?
I think it's more of a logic problem than computing.
Thanks
If I increase the value of A1, A2 goes down, such that they always sum to 100. This has been done and works.
However, if I have 3 scrollbars, which also must sum to 100, (with initial values of 10, 20 and 70), is there a way such that when scrollbar one's value increases, (say from 10 to 11), that scrollbars 2 and 3 automatically decrease to 19.5 and 69.5, so that now 11+19.5+69.5 = 100?
I think it's more of a logic problem than computing.
Thanks