1. 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

2. For the sales person use .05 * something for the company use (discount-0.05)*something.

3. perhaps

SalesmansDiscount = MIN(totalDiscount/2, .05)

CompanyDiscount = totalDiscount - SalesmansDiscount

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•