I have a worksheet with two totals – one for the sales persons totals and one for the company’s totals and additional columns for discount percentages. Depending on the % discount given at the sale the split is different between the sales person and the company.
For example if the item is sold with a 10% discount, the sales person has 5% of that discount deducted from their total and the company has 5% deducted from their total. However if the discount is 20%, the sales person has 5% of the discount deducted from their account and the company has 15% deducted. If 15% discount is given the sales person has 5% deducted and the company has 10% deducted.
Basically the sales person always has at least 5% deducted and the company has the balance of that discount deducted from their total.
I would like a formula to look at the % of discount given and calculate the correct amount for the sales person and the company based on the above rates.
thanks
