questionmark1980
New Member
- Joined
- Dec 4, 2016
- Messages
- 9
Hello
Let’s say I’m offering my customers a discount where if a customer achieves a growth rate of over 5% vs last year I will pay this customer a % discount based on the turnover level. So customer Z meets the eligibility criterion for the growth (over 5%) and based on his turnover he should be getting 1%. So total discount that he should be getting is 80. What would be the formula that should be used so as to get the 80 in cell F7 and zero in cells D7, E7 and G7?
Any help would be highly appreciated
<colgroup><col width="64" style="width: 48pt;">
<col width="106" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3876;">
<col width="64" style="width: 48pt;">
<col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;">
<col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" span="4">
<tbody>
</tbody>
Let’s say I’m offering my customers a discount where if a customer achieves a growth rate of over 5% vs last year I will pay this customer a % discount based on the turnover level. So customer Z meets the eligibility criterion for the growth (over 5%) and based on his turnover he should be getting 1%. So total discount that he should be getting is 80. What would be the formula that should be used so as to get the 80 in cell F7 and zero in cells D7, E7 and G7?
Any help would be highly appreciated
A | B | C | D | E | F | G | |
1 | |||||||
2 | 0,00 € | 1.001,00 € | 2.001,00 € | 8.001,00 € | |||
3 | 1.000,00 € | 2.000,00 € | 8.000,00 € | over 8001 | |||
4 | Customer name | Growth | Turnover | 0% | 0,5% | 1,00% | 2,00% |
5 | Customer X | -10,00% | 5.000,00 € | Discount? | |||
6 | Customer Y | 4,00% | 30.000,00 € | ||||
7 | Customer Z | 6,00% | 8.000,00 € | ||||
8 | Customer D | 7,00% | 3.000,00 € |