title: Excel Formula- Divide a sum into multiple cells?
body: <p>I need a formula for excel that will allow me to take a sum and divide it up into a number of cells.</p>
  
  <p>for example:</p>
  
  <p>A1= sum</p>
  
  <p>B1 to B4 needs to have a portion of the devided sum</p>
  
  <p>i.e. if sum 1000 then B1=100 B2=200 B3=300 B4=400</p>
  
  <p>Thank's in advance guys</p>
  
  <p>The decomposition rule is that it goes from B1 to B4 in intervals of 100...adding to the pervious</p>