Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2009
    Posts
    29
    Thanks
    1
    Thanked 0 Times in 0 Posts
    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. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    For the sales person use .05 * something for the company use (discount-0.05)*something.


    Please post a sample of your workbook if this solution is not adequate.

  3. #3
    Lounger
    Join Date
    Sep 2008
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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
  •