angelocyrl
New Member
- Joined
- Feb 28, 2010
- Messages
- 21
Hi!
Here is the values and conditions:
<tbody>
</tbody>
Coniditions:
Target < 15000 commission is '0'
Target > 15000 < 30000 is 2% calculate commission value
Target > 30000 < 45000 is 3% calculate commoission value
Target > 45000 < 60000 is 4% calculate commission value
Target above > 60000 is 5% calculate commission value
Display commission value in C column
Thank you in advance.
Here is the values and conditions:
A | B | C | |
1 | Customer | Target Achieved | Commission |
2 | Bernard | 54882 | |
3 | Norbert | 13420 | |
4 | Maggie | 91472 | |
5 | Smilly | 33542 |
<tbody>
</tbody>
Coniditions:
Target < 15000 commission is '0'
Target > 15000 < 30000 is 2% calculate commission value
Target > 30000 < 45000 is 3% calculate commoission value
Target > 45000 < 60000 is 4% calculate commission value
Target above > 60000 is 5% calculate commission value
Display commission value in C column
Thank you in advance.