A | B | C | |||||||||||||||
1 | Range | No. of Deliveries | Inventive | ||||||||||||||
2 | 0-4 | Zero | |||||||||||||||
3 | 5-8 | ₹ 5.00 | |||||||||||||||
4 | 9-14 | ₹ 10.00 | |||||||||||||||
5 | 15-18 | ₹ 15.00 | |||||||||||||||
6 | 18 Onwards | ₹ 20.00 | |||||||||||||||
7 | |||||||||||||||||
8 | No. of Deliveries | Inventive | |||||||||||||||
9 | 25 | ??? | |||||||||||||||
10 | 10 | ??? | |||||||||||||||
<tbody>
</tbody>
deliveries that a person does,
Column C has the incentive that will be paid to the person for doing this in the range.
Suppose a person does :
4 deliveries : he gets nothing
7 deliveries : he gets 3*5=15
10 deliveries : he gets (from 5-8 he gets 4*5=20) + 2 deliveries within
range 9-14 ie. (2*10=20) So he get total of 20+20=40
25 deliveries: he gets Range 5-8 = 4 @5=20; Range 9-14=6 @10= 60;
Range 15-18=4 @15=60; and Range 18 onwards =8 @20 =160: Total incentive becomes 20+60+60+160= 300
What I want is that when I enter the no. of deliveries it formula should calculate the amount automatically? What should be the formula in this case.
Many thanks for the support.