<div>
You can use the PERCENTILE function instead. You can use PERCENTILE(array,.2), PERCENTILE(array,.4), etc.<br />
<br />
In which case they are quintiles (if that's what they're called), not quartiles.
</div>


<div>
I want to get the result like 1 , 2 , 3 , 4 or 5 base on <br />
<br />
case &nbsp; if cell(&quot;B2&quot;).value is &lt;&nbsp;PERCENTILE(B2:B50 , .2 )<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
case &nbsp; if cell(&quot;B2&quot;).value is &lt;&nbsp;PERCENTILE(B2:B50 , .4 )<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
case &nbsp; if cell(&quot;B2&quot;).value is &lt;&nbsp;PERCENTILE(B2:B50 , .6 )<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3<br />
case &nbsp; if cell(&quot;B2&quot;).value is &lt;&nbsp;PERCENTILE(B2:B50 , .8 )<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4<br />
case &nbsp; if cell(&quot;B2&quot;).value is &lt;&nbsp;PERCENTILE(B2:B50 , 1 )<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5
</div>


<div>
<div class="content wysiwyg-content">
How can I calculate the QUARTILE into 5 section for example QUARTILE(B2:B50,5)<br />
<br />
1 &nbsp; &lt;&nbsp;.2<br />
2 &nbsp; &lt;&nbsp;.4<br />
3 &nbsp; &lt;&nbsp;.6<br />
4 &nbsp; &lt;&nbsp;.8<br />
5 &nbsp; &lt;&nbsp;1
</div>
</div>


How can I calculate the QUARTILE into 5 section for example QUARTILE(B2:B50,5)

1   < .2
2   < .4
3   < .6
4   < .8
5   < 1

How to calculate the  QUARTILE ?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.