I have a constant number X. I also have two numbers that add up to it. How can I make it so that if I change one number, the other number automatically changes so that it still adds up to X.

I have tried to take subtract the one number from X and add it to the other number, but instead I got two numbers in the thousands.

CodePudding user response：

Assuming your constant value is 10, you can set this in a cell and make all your other calculations based on it.

For example, you can have cell C2 containing your constant, in this example, 10

Then in C4 you can have the number which you change, and the value of C5 will be equal to the value of the constant minus the value in C4.

You can then finally do your sum wherever you want, adding up the values of C4 and C5.

Here's an example Spreadsheet:

Untitiled spreadsheet ☆

File Edit View Insert Format Data Tools Extensions Help _{Last edit was 2 minutes ago}

↶ ↷