I have a newly added responsibility at work and one of my new tasks is figuring out commissions for our outside sale team. We have 5 different percentage rates we pay out depending on the type of sale and amount of sale. The person now appears to be doing a rather tedious method of using a calculator. What I tried to find searching google mainly focused on sliding commission rate. What I would like is a macro that has some way of me entering in dollar amounts into these rates. 3%, 4%, 5%, 6% and 7%. What would be great is a cumulative commission total. So I could see me entering 3 totals for the 3%, 6 on the 5% and 30 into the 7%. I hope this is enough information. Please ask any question you may need.
As always many thanks for your help on this