How do i keep the total of 3 variables constant

  • Thread starter southwestpaddler
  • Start date
S

southwestpaddler

I want to input 3 variables into my spreadsheet, each needs to be able to be
altered but the total must never be more than 100. Can the other cells be
automatically altered to achieve this?
 
N

Niek Otten

In what way?

a: 20, b: 50, c:30

Change 1 to 15
What should b and c be? Why? What are your "rules"?
 
S

southwestpaddler

If a is changed b and c must change to maintain the total of 100. A possible
inclusion of an option to keep a certian variable constant would be good too.

Thanks
 
Top