# Formula's For Calculate Sales Commissions

Jan 2, 2008I am trying to decipher how to calculate commissions for my sales reps. I have made just a simple spreadsheet to give you an idea of what I am doing. I have tried to us an IF formula but I think there are too many options( I have 9 reps). Basically I pay them either 10 or 15% so I need a formula to take the sales price - cost times their apporpriate %.

AgentSales Price CostComm Pd

AS150 75

JK255 185

JD325 250

JD125 50

AS50 10

AS50 10

AS335 250

JW75 25