trying to forumlate a worksheet for monthly commission payments.
sold less than 60,000 so far in the year you get 3% commission paid that month
between 60,000-100,000 4.8%
over 100,000 7.5%
e.g
so if year to date (jan & feb) you had sold 70,000 and you sold another 20,000 in march you would get paid 4.8% of the 20,000 in march
if in jan & feb you had sold 55,000 year to date and you sold 20,000 in march you would get paid 5,000 at 3% and 15,000 at 4.8%
tried so many different ways of working it out and failed miserably, can someone help please!
sold less than 60,000 so far in the year you get 3% commission paid that month
between 60,000-100,000 4.8%
over 100,000 7.5%
e.g
so if year to date (jan & feb) you had sold 70,000 and you sold another 20,000 in march you would get paid 4.8% of the 20,000 in march
if in jan & feb you had sold 55,000 year to date and you sold 20,000 in march you would get paid 5,000 at 3% and 15,000 at 4.8%
tried so many different ways of working it out and failed miserably, can someone help please!