Math formula help

[Noxqss38242]

example: A1 = 1000
B2 = 300

If A1 increases, then B2 needs to decrease the same value that A1 increased.

 

[CA_Punit]

Please type the changes in C1 and automatically A1 and B1 will change

Book1
	A	B	C	D
1	1010	290	10
2
3
4
5
Sheet1

Cell Formulas
Range	Formula
A1	A1	=1000+C1
B1	B1	=300-C1

 

[Rick Rothstein]

Assuming you are going to type a new value in cell A1, put this formula in cell B1...

=1300-A1

This formula was derived from this formula version of your description...

=300-(A1-1000)