sing2trees1983
New Member
- Joined
- Feb 3, 2006
- Messages
- 26
Hi,
I have a spreadsheet which has:
Col A: Supplier
Col B: Units Sold
Col C: Total Sales
In column D, I need to show the commission for the total sales. However it varies on the supplier and units sold. Ie supplier 1 there is 20% commission regardless of units sold, supplier 2 is 25% commission for 1-49 units and 20% commission for 50+ units.
Is there an easy formula I can use to calculate the commission in column D?
Many thanks in advance!
I have a spreadsheet which has:
Col A: Supplier
Col B: Units Sold
Col C: Total Sales
In column D, I need to show the commission for the total sales. However it varies on the supplier and units sold. Ie supplier 1 there is 20% commission regardless of units sold, supplier 2 is 25% commission for 1-49 units and 20% commission for 50+ units.
Is there an easy formula I can use to calculate the commission in column D?
Many thanks in advance!
