Calculating Percentage

[Fyrdawg]

Hi.. I am trying to correct my formula to calculate the 90% of K3:K281, if D3:D281 equals, 1,3,4,and 5. I am using the formula below to get the 90% for each number individually, but can't get it to work for all 4 numbers combined.

My formula is: =PERCENTILE((IF(D3:D281="1",K3:K281)),0.9)

Any help is always greatly appreciated.

 

[AhoyNC]

These are array formulas that must be entered with CTRL-SHIFT-ENTER.

If your range D3:D281 is numeric then:
=PERCENTILE(IF(D3:D281={1,3,4,5},K3:K281),0.9)

If the range D3:D281 is text then:
=PERCENTILE(IF(D3:D281+0={1,3,4,5},K3:K281),0.9)

 

[Fyrdawg]

Dang. That was to obvious. Thank you...

 

[AhoyNC]

You're welcome. Thanks for the feedback.