Hi I was hoping someone could help me we a formula that I've been working on
I am trying to build a progressive commission tier table and have it pretty much working other than the first payment level.
When I put £1000 it calculates at zero, as shown below
And if I put in £2000 of sales generated it only calculates £1000 x 2% rather than the full £2000
Can someone please help with this?
I am trying to build a progressive commission tier table and have it pretty much working other than the first payment level.
When I put £1000 it calculates at zero, as shown below
And if I put in £2000 of sales generated it only calculates £1000 x 2% rather than the full £2000
Can someone please help with this?