I am trying to build a spreadsheet for my sales reps for their commission but get stuck on the percentage formulas. in this specific case im looking to do the following
15 sales is monthly quota and should be 100% of the quota each sale is paid at $50.00 each at 100% rate. if the sales rep only sells 5 they would be paid whatever the % of he $ amount is of the 15 minimum quota. now if the sell anything over the 100% minimum quota the $50.00 rate should change to reflect the increase over 100%. Any help would be greatly appreciated. Thanks
Bookmarks