Good day everyone
I apologise that I may have asked this question before, But I recently lost all my laptop and all backups ( and attemps to search for my previous posts show only 6 previous posts )
In the example shown:
In coulmn E, I am looking for a formula that will return the "% Contr", from column F, if it falls into the top 60% ( Or whatever % I put into cell E2 & E3 ) - Another variation would be to return a message ( Like : Good, Bad etc - If I wanted to marked the numbers that make up the bottom 25% for example)
Thanks for your help
I apologise that I may have asked this question before, But I recently lost all my laptop and all backups ( and attemps to search for my previous posts show only 6 previous posts )
In the example shown:
In coulmn E, I am looking for a formula that will return the "% Contr", from column F, if it falls into the top 60% ( Or whatever % I put into cell E2 & E3 ) - Another variation would be to return a message ( Like : Good, Bad etc - If I wanted to marked the numbers that make up the bottom 25% for example)
Thanks for your help
test top80 perc.xls | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | %Contrmakingupthe | ||||||
2 | Top | ||||||
3 | Product | Sales | %Grwth | %Contr | 60% | ||
4 | Category1 | 13,558 | 0.00% | 0.00% | |||
5 | Category2 | 1,183 | 0.00% | 0.00% | |||
6 | Category3 | 129,595,201 | -16.49% | 30.48% | 30.48% | ||
7 | Category4 | 166,860 | 279.58% | 0.04% | |||
8 | Category5 | 14,604,475 | 36.21% | 3.44% | |||
9 | Category6 | 276,546 | 2587.92% | 0.07% | |||
10 | Category7 | 1,295 | -85.91% | 0.00% | |||
11 | Category8 | 122,834 | 149.71% | 0.03% | |||
12 | Category9 | 125,237,206 | -28.83% | 29.46% | 29.46% | ||
13 | Category10 | 7,984,811 | 31.55% | 1.88% | |||
14 | Category11 | 4,977,496 | 3.42% | 1.17% | |||
15 | Category12 | 7,755,973 | 46.23% | 1.82% | |||
16 | Category13 | 20,497 | 0.00% | 0.00% | |||
17 | Category14 | 55,083,866 | 11.21% | 12.96% | |||
18 | Category15 | 6,295,733 | 31.29% | 1.48% | |||
19 | Category16 | 54,712,449 | 9.44% | 12.87% | |||
20 | Category17 | 6,524,887 | -8.16% | 1.53% | |||
21 | Category18 | 1,730,474 | 11.08% | 0.41% | |||
22 | Category19 | 38,783 | -18.43% | 0.01% | |||
23 | Category20 | 0 | -100.00% | 0.00% | |||
24 | Category21 | 3,838,367 | 6031.77% | 0.90% | |||
25 | Category22 | 6,181,686 | -32.27% | 1.45% | |||
26 | Total | 425,164,180 | -11.61% | 100.00% | |||
27 | |||||||
28 | IncoulmnE,Iamlookingforaformulathatwillreturnthe"%Contr",fromcolumnF,ifitfallsintothetop60%(Orwhatever%IputintocellE2&E3)-Anothervariationwouldbetoreturnamessage(Like:Good,Badetc-IfIwantedtomarkedthenumbersthatmakeupthebottom25%forexample) | ||||||
29 | |||||||
30 | |||||||
31 | |||||||
32 | |||||||
33 | |||||||
Sheet3 |