Hello, I am trying to program a balanced sum into Excel and am coming across some difficulty. I'm hoping someone can help me.
Here is what I'm trying to do: I have a list of numbers that should always equal a set sum (for example, ten). If I increase one of the numbers, I want the others to all decrease proportionately so that the sum stays the same. So, for example, if the balanced sum is ten and there are ten numbers in the list, they should all start of as equaling 1. However, if I increase one of the cells to 2, then the others should all decrease to 8/9 so that the sum stays 10. The difficulty I'm finding is that each cell needs to be a variable in a sort of way.

Thank you very much.