Exclude Some cells from percentile formula

[immohi]

How can I exclude cells having value less than 29 from array(column) which have values between 0 to 100.

I have to calculate percentile from renaming values.

Total
38
51
72
59
45
77
40
76
82
71
68
29
50
0
53
54
52
20
65

<tbody>
</tbody>

PERCENTILE	92	85	70	50	30	15
Cut-off	76.56	73.2	66.8	53	47	35.3

<tbody>
</tbody>

formula : =PERCENTILE($A$2:$A$20,0.92).

Expected Result:

PERCENTILE	92	85	70	50	30	15
Cut-off	76.8	75	69.5	56.5	51.5	46.25

<tbody>
</tbody>

Thanks

 

[Andrew Poulsom]

Formula in D2 copied across:

Excel 2010
	A	B	C	D	E	F	G	H	I
1	Total		PERCENTILE	92	85	70	50	30	15
2	38		Cut-off	76.8	75	69.5	56.5	51.5	46.25
3	51
4	72
5	59
6	45
7	77
8	40
9	76
10	82
11	71
12	68
13	29
14	50
15	0
16	53
17	54
18	52
19	20
20	65
Sheet1

Cell Formulas
Range	Formula
D2	{=PERCENTILE(IF($A$2:$A$20>29,$A$2:$A$20),D1%)}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[immohi]

Formula in D2 copied across:

Excel 2010

	A	B	C	D	E	F	G	H	I
1	Total		PERCENTILE	92	85	70	50	30	15
2	38		Cut-off	76.8	75	69.5	56.5	51.5	46.25
3	51
4	72
5	59
6	45
7	77
8	40
9	76
10	82
11	71
12	68
13	29
14	50
15	0
16	53
17	54
18	52
19	20
20	65

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Array Formulas Cell Formula D2 {=PERCENTILE(IF($A$2:$A$20>29,$A$2:$A$20),D1%)} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

Thank you Sir.