geckosigns
New Member
- Joined
- Aug 8, 2009
- Messages
- 2
Hello,
I'm having a heck of a time figuring out how i can set up my commission rate in excel for my company. Our scale is as follows:
Margin % is in cell F7
Profit Dollar amount is in cell F6
under 20% margin pay 15% commission on profit
21% to 30% margin pay 20% commission on profit
31% to 40% margin pay 25% commission on profit
41% to 50% margin pay 30% commission on profit
over 50% margin pay 35% commission on profit
Any help would be greatly appreciated!
Thanks
I'm having a heck of a time figuring out how i can set up my commission rate in excel for my company. Our scale is as follows:
Margin % is in cell F7
Profit Dollar amount is in cell F6
under 20% margin pay 15% commission on profit
21% to 30% margin pay 20% commission on profit
31% to 40% margin pay 25% commission on profit
41% to 50% margin pay 30% commission on profit
over 50% margin pay 35% commission on profit
Any help would be greatly appreciated!
Thanks