having a problem with the forumula's in setting up a commission calculator
that calculates accumulative commision
the structures are as follows:
an example of the payment are as follows:
- Sales from Band 1: £0 to £4999 = zero % commission
- Sales from Band 2: £5000 to £8000 = 10% commission
- Sales from Band 3: £8001 to £12000 = 15% commission
- Sales from Band 4: £12001 to £15000 = 20% commission
- Sales from Band 5: £15001 to £25000 = 25% commission
- Sales from Band 6: £25001 and above = 30% commission
- £6,000 = £ 100
- £8,000 = £ 300
- £10,000 = £ 600
- £12,000 = £ 900
- £15,000 = £1,500
- £18,000 = £2,250
- £20,000 = £2,750
- £28,000 = £4,900
Thanks
Outspokensa
Bookmarks