title: random number based on probability in Excel
body: <p>How can I create a random number generator which calculates a random number based on a probability?</p>
  
  <p>For example, I have the following numbers with the probability they will occur starting in cell A1 and B1:</p>
  
  <pre><code>100 5%
  75  10%
  50  42%
  30  30%
  15  5%
  0   8%
  </code></pre>
  
  <p>Thus, the formula would "randomly" return the number "15" 5% of all times.</p>