screenplay greg
New Member
- Joined
- Oct 27, 2002
- Messages
- 8
I'm trying to create a spreadsheet to calculate commissions based on a cumulative sales amount. The commission % is based on a sliding scale. When the cumulative gets over a amount then the commission rate changes.
I'm having trouble figuring out how to utilize the IF or Vlookup functions.
For example if the cumulative commissions go from 100 to 300 in one month and the commission changes at the 200 point how can I structure an argument to make sure that the portion from 101-200 gets calculated at one rate while the amount over 200 gets calculated at the new rate ?
I hope this makes sense.
Thanks
I'm having trouble figuring out how to utilize the IF or Vlookup functions.
For example if the cumulative commissions go from 100 to 300 in one month and the commission changes at the 200 point how can I structure an argument to make sure that the portion from 101-200 gets calculated at one rate while the amount over 200 gets calculated at the new rate ?
I hope this makes sense.
Thanks