Help with Formula

[Kristylee0228]

I've created a heat map and I am wondering how to use a percentage in my formula instead of MIN and MAX.
Here is my formula now: =IF($B8<>"",IF(W103=MAX(W$103:W$113),"p",IF(W103=MIN(W$103:W$113),"q","n")),"")

I need to show the top 30% of a group and the bottom 30% of the group. Anything in between would be the median.

Any help would be greatly appreciated.

 

[AlphaFrog]

Hi and welcome.

Maybe try something like this...

=IF($B8<>"",IF(W103<=PERCENTILE(W$103:W$113,30%),"Bottom30%",IF(W103>=PERCENTILE(W$103:W$113,70%),"Top30%","Median")),"")

 

[Kristylee0228]

thank you soo much!
worked!!