Forum Discussion
Solved
Incentive Calculation Formula
HI Can any one help me with creating a formula for below type of incentive structure. Sl. No Transaction slab Amount in Rs Amount in Rs 1 0 - 20,000 100 2 20,001 - 40,000 100 3 40,001 - 60,0...
With a transaction amount in T2:
=CEILING(T2,20000)/200+QUOTIENT(T2,100000)*100+LOOKUP(T2,{0,1000000,1500000,2500000},{0,2000,3500,7000})
This can be filled down.
With a transaction amount in T2:
=CEILING(T2,20000)/200+QUOTIENT(T2,100000)*100+LOOKUP(T2,{0,1000000,1500000,2500000},{0,2000,3500,7000})
This can be filled down.
- Thanks a lot for quick response.
