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 ...
Its pretty easy, simply multiply all cells and drag formula down till last cell of column.
Eg. Your table has 3 columns, column A Product, Column B Price, Column C Commission. In new column use this formula B1*C1
This will definitely give you commition%
Eg. Your table has 3 columns, column A Product, Column B Price, Column C Commission. In new column use this formula B1*C1
This will definitely give you commition%
Thank you.