pfa the file and give me the solution required.
SL no Amount Incentive Range incentive Slab
1 100 0 0-150 0%
2 150 0 151-500 3.50%
3 510 FALSE 501-999 3.75%
4 700 FALSE 1000-1999 4%
5 1050 FALSE 2000-2999 4.50%
6 2010 FALSE > 3000 4.75%
7 3020 FALSE
I need the incetive formula in incetive column...please do the needful.
Bookmarks