Forum Discussion
Trying to figure out how to calculate various commission rates on the same spreadsheet
Hi, I am trying to figure out how to add a column to calculate commissions on an excel spreadsheet that has multiple items (with several orders for each item) and each have a different price and ...
You might consider a more dynamic solution by creating a product list with prices and commission %. Then you record all Sales transaction in another list and pick-up the prices and commissions from the other list. You can then create a, for example, a pivot table to summarise sales and commissions by month. Have a look at the attached workbook to see if this meets your requirements.