'How to update the contents of one cell based on the contents inputted inside another cell?
I want a cell to automatically update when the contents in another cell are changed so that the data in both the cells fit a function. For example I have some data in B2 and some other data in B3, I want there to be a kind of restrain of B2+B3 = 29. Suppose that B2 has a data of value x and B3 has a data of value y,so if I change B1 from say x to x+7, then the data in B2 should go from y to y-7.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|