title: cells updating according to each other values
body: <p>So the idea is to have a set sum value for 2 or more cells and if we change one of the cells value, it distripute the changed value on the other connected cells.<br></p>
  <p>⠀</p>
  <p>Let's say we have 2 Clients paying for the same Item:</p>
  <p><strong>Client 1 payed the full $100</strong><br>
  <a href="https://i.stack.imgur.com/ujLut.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ujLut.png" alt="enter image description here" /></a></p>
  <p>⠀</p>
  <p>⠀</p>
  <p><strong>Then Client 2 payed $30 to us, which then we pay client 1 back</strong><br>
  <a href="https://i.stack.imgur.com/EuprB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EuprB.png" alt="enter image description here" /></a></p>
  <p>⠀</p>
  <p>⠀</p>
  <p><strong>Then Client 2 Personally payed Client 1 $20</strong><br>
  <a href="https://i.stack.imgur.com/QFZ2y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QFZ2y.png" alt="enter image description here" /></a></p>
  <p>so the question is:<br>
  Can I have 2 or more cells updating their values according to each other.</p>
  <p>⠀</p>
  <p>Edit1:<br>
  I didn't say what are the changing variables are.<br>
  <code>Clients</code>: there can be more than 2<br>
  <code>Item</code>: unchanging<br>
  <code>Price</code>: chainging<br></p>