title: Excel - Multiply Until Total Reached
body: <p>I want to multiply <code>x*y until x&gt;=20</code>, then multiply z that value and have the results displayed as two values, the multiple and <code>multiple*z</code></p>
  
  <p>The question behind the formula is, how many boxes of x capacity do I need to have a total capacity of 20 liters and how much does that cost.</p>
  
  <pre><code>x = volume of bottle
  y = number of bottles in a box
  z = price per box
  </code></pre>
  
  <p>This could be done very easily by hand, but I've been playing (with little effect) in excel for a while and would like a solution.</p>
  
  <p>I hope that makes sense</p>