Forum Discussion
Calculating the sum of incentive amount for each sales person with a given condition
Hello guys, I am stuck in a calculation. Actually, I am reporting a sheet on a daily basis recently i've added a column called incentive amount and i was calculating total sum of incentive amount for...
Can any one help me with creating a formula for below type of incentive structure.
| SLAB/LAKHS | MINIMUM ELIGIBLE NO | MINIMUM ELIGIBLE VOLUME | INCENTIVE | |
| SLAB 1 | 300 | 2 | 10 | 3000 |
| SLAB 2 | 450 | 3 | 15 | 6750 |
| SLAB 3 | 650 | 4 | 20 | 13000 |
| SLAB 4 | 750 | 5 | 25 | 18750 |
| SLAB 5 | 850 | 6 | 30 | 25500 |
conditions:
Example
If done in volume 30 lakhs but in numbers they done 4 nos will get the SLAB 3 calculation
how to calculate above mentioned slab in both volume and number terms
pls any one help on this