title: What's the logic behind PERCENTILE.INC Excel function?
body: <p>I would like to know how does Excel think to calculate the values on the function PERCENTILE.INC. I'm making some studies on Percentile and Quartile, I got the below results:</p>
  <p><a href="https://i.stack.imgur.com/4FGg5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4FGg5.png" alt="Percentile Example" /></a></p>
  <p>How does Excel think to calculate the values on column F?</p>
  <p>Here's the formulas I'm using:</p>
  <ul>
  <li>=PERCENTILE.INC(B2:B21; 0,75) ==&gt; F2</li>
  <li>=PERCENTILE.INC(B2:B21; 0,50) ==&gt; F3</li>
  <li>=PERCENTILE.INC(B2:B21; 0,25) ==&gt; F4</li>
  <li>=PERCENTILE.INC(B2:B21; 0,00) ==&gt; F5</li>
  </ul>