We help IT Professionals succeed at work.

# How to calculate the  QUARTILE ?

on
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
Comment
Watch Question

## View Solution Only

Commented:
You can use the PERCENTILE function instead. You can use PERCENTILE(array,.2), PERCENTILE(array,.4), etc.

In which case they are quintiles (if that's what they're called), not quartiles.

Commented:
=PERCENTILE(B2:B50,5)

Commented:
I want to get the result like 1 , 2 , 3 , 4 or 5 base on

case   if cell("B2").value is < PERCENTILE(B2:B50 , .2 )
1
case   if cell("B2").value is < PERCENTILE(B2:B50 , .4 )
2
case   if cell("B2").value is < PERCENTILE(B2:B50 , .6 )
3
case   if cell("B2").value is < PERCENTILE(B2:B50 , .8 )
4
case   if cell("B2").value is < PERCENTILE(B2:B50 , 1 )
5
Commented:
Like this?

=IF(B2<PERCENTILE(B2:B50,0.2),1,IF(B2<PERCENTILE(B2:B50,0.4),2,IF(B2<PERCENTILE(B2:B50,0.6),3,IF(B2<PERCENTILE(B2:B50,0.8),4,5))))

Commented:
Thanks