title: Excel: Distribute one percentage through multiple cells
body: <p>I have cells with the following percentages:</p>
  
  <p>A1 = 81% <br />
  A2 = 15% <br />
  A3 = 3% <br />
  A4 = 1% <br /></p>
  
  <p>I'm trying to make it so whatever is in A1 gets redistributed across the values in A2, A3, and A4 with the same ratio between them. For example, A4 to A3 is a 3x increase and A3 to A2 is a 5x increase. So distributing the 81% will make the new values in A2, A3, and A4 equal 100% but maintain the original ratio.</p>
  
  <p>So, for the above example, taking 81% and distributing across A2, A3, and A4 you'd get the following values:</p>
  
  <p>B2 = 64% <br />
  B3 = 13% <br />
  B4 = 4% <br />
  B2 + B3+ B4 = 81 (value in A1) <br /></p>
  
  <p>The Ratio won't always be perfect due to rounding, which is fine.</p>
  
  <p>If you add the A2 + B2, A3 + B3, A4 + B4, and sum it all you get 100%. The goal is to get this to work regardless of the original 4 starting numbers in A1:A4.</p>
  
  <p>Thanks!</p>