Tripleseas
Board Regular
- Joined
- Jul 12, 2022
- Messages
- 87
- Office Version
- 2013
- Platform
- Windows
hello comunity,
I want to write a formula in C column that will do the following :
Depending on each line , the formula need to look in the parametres table if that line is groupe 1 and the % is higher than 200% then its eligibile other than that its not.
the formula need to be flexible so when i change the parameters in the table the results will be updated.
thank you
I want to write a formula in C column that will do the following :
Depending on each line , the formula need to look in the parametres table if that line is groupe 1 and the % is higher than 200% then its eligibile other than that its not.
the formula need to be flexible so when i change the parameters in the table the results will be updated.
thank you
Classeur1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | groupe | % | éligible yes or no | ||||||
2 | Groupe 1 | 84% | NO | ||||||
3 | Groupe 1 | 96% | |||||||
4 | Groupe 1 | 103% | Groupes | % range | |||||
5 | Groupe 1 | 104% | Groupe 1 | > 200% | |||||
6 | Groupe 1 | 135% | Groupe 2 | > 150% | |||||
7 | Groupe 1 | 73% | Groupe 3 | > 130% | |||||
8 | Groupe 1 | 130% | |||||||
9 | Groupe 1 | 120% | |||||||
10 | Groupe 1 | 131% | |||||||
11 | Groupe 1 | 144% | |||||||
12 | Groupe 1 | 80% | |||||||
13 | Groupe 1 | 177% | |||||||
14 | Groupe 1 | 89% | |||||||
15 | Groupe 1 | 114% | |||||||
16 | Groupe 1 | 93% | |||||||
17 | Groupe 1 | 166% | |||||||
18 | Groupe 2 | 94% | |||||||
19 | Groupe 2 | 99% | |||||||
20 | Groupe 2 | 120% | |||||||
21 | Groupe 2 | 135% | |||||||
22 | Groupe 2 | 84% | |||||||
23 | Groupe 2 | 125% | |||||||
24 | Groupe 2 | 152% | YES | ||||||
25 | Groupe 2 | 114% | |||||||
26 | Groupe 2 | 100% | |||||||
27 | Groupe 2 | 103% | |||||||
28 | Groupe 3 | 86% | |||||||
29 | Groupe 3 | 109% | |||||||
30 | Groupe 3 | 131% | |||||||
31 | Groupe 3 | 79% | |||||||
32 | Groupe 3 | 81% | |||||||
33 | Groupe 3 | 89% | |||||||
34 | Groupe 3 | 135% | |||||||
35 | Groupe 3 | 121% | |||||||
36 | Groupe 3 | 89% | |||||||
37 | Groupe 3 | 93% | |||||||
38 | Groupe 3 | 174% | |||||||
39 | Groupe 3 | 95% | |||||||
40 | Groupe 3 | 98% | |||||||
41 | Groupe 3 | 101% | |||||||
Feuil1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
B2:B41 | Other Type | DataBar | NO |