HR Manager
New Member
- Joined
- Jul 13, 2018
- Messages
- 3
I am trying to get commission values to generate based upon three criteria's:
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The commission structure is below:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
How the structure works that the employee must hit the minimum in three column in order to recieve the commission value
For example:
Employee A: would get 40
Employee B: would receive 0
Employee C: would receive 0
I have tried Index, match and vlookup, with if and I am not getting the results I need. Any help would be much appreciated.
Employee | LPH | QA Score | DH |
A | 4.6 | 0.967 | 37.9 |
B | 3.5 | 0.951 | 25.6 |
C | 1.7 | 0.981 | 29.2 |
D | 3.4 | 0.912 | 37.2 |
E | 7 | 0.964 | 15 |
F | 2.1 | 0.863 | 20 |
G | 5.5 | 1 | 29.5 |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The commission structure is below:
LPH | QA | DH | Commission |
0 | 0 | 0 | 0 |
4 | 0.96 | 34 | 40 |
5 | 0.96 | 34 | 80 |
6 | 0.97 | 34 | 120 |
7 | 0.97 | 36 | 160 |
8 | 0.97 | 36 | 200 |
9 | 0.98 | 36 | 240 |
10 | 0.98 | 36 | 280 |
11 | 1 | 36 | 320 |
12 | 1 | 36 | 360 |
13 | 1 | 36 | 400 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
How the structure works that the employee must hit the minimum in three column in order to recieve the commission value
For example:
Employee A: would get 40
Employee B: would receive 0
Employee C: would receive 0
I have tried Index, match and vlookup, with if and I am not getting the results I need. Any help would be much appreciated.