title: How to fix 'PERCENTILE' formula in cells
body: <p>I have 5 cells that are supposed to take the percentage from a column range in a table. Each cell is supposed to represent a number value of 1,2,3,4,5 respectively. This is how it is supposed to be formatted:</p>
  
  <p>1 = 0-20%</p>
  
  <p>2 = 20-33%</p>
  
  <p>3 = 33-50%</p>
  
  <p>4 = 50-70%</p>
  
  <p>5 = 70-100%</p>
  
  <p>Here is how I have the current formula for each cell, with the appropriate percentage value for each:</p>
  
  <p><code>=IF(ISERROR(PERCENTILE($N11:$N2208,0.2)),"",PERCENTILE(IF($N11:$N2208&gt;0,$N11:$N2208),0.2))</code></p>
  
  <p>Pictures of each output:</p>
  
  <p><a href="https://i.stack.imgur.com/PXTAE.png" rel="nofollow noreferrer">Formula and current outputs</a></p>
  
  <p>Column for percentages input:</p>
  
  <p><a href="https://i.stack.imgur.com/vOvjD.png" rel="nofollow noreferrer">Column</a></p>
  
  <p>I am not sure what is wrong in my formula but I know it is wrong since 1,2 &amp; 3 have the same output values. Also, the 100% value is 427% and the 20% value is 2.33%, this just doesn't make sense. </p>
  
  <p>Can someone tell me what is wrong or why this is happening?</p>