# Scaling discount based on growth condition

#### questionmark1980

##### New Member
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

 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 €
<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>

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### questionmark1980

##### New Member
This is a little different.. This has two conditions. The other one has only one condition.
I also tried the formula suggested in this other thread but it does not work for this mechanism.

Replies
3
Views
692
Replies
1
Views
2K
Replies
3
Views
3K
Replies
1
Views
643
Replies
1
Views
1K

1,191,516
Messages
5,987,038
Members
440,074
Latest member
Emmanuelian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back