+ Reply to Thread
Results 1 to 2 of 2

Deduct (percentage) amounts off of specific quantity ranges

  1. #1
    Registered User
    Join Date
    06-09-2014
    Posts
    1

    Deduct (percentage) amounts off of specific quantity ranges

    Hello all,


    I'm interested in learning how to deduct a percentage off of a range of units.

    For example, if I have 100 units that cost $50, I'd like to deduct 20% off of the first 10 units, and then have the total dollar amount put into a separate cell.

    So, 100 x $50 = $5000

    With 20% off of the first 10 units: $4900.

    __________________________

    20% of $50 = $10

    $10 x 10 units = $100

    $5000 - $100 = $4900

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Deduct (percentage) amounts off of specific quantity ranges

    =(DiscountQuantity*(ListPrice*(1-Discount%)))+((TotalQuantity-DiscountQuantity)*ListPrice)
    Last edited by gak67; 06-09-2014 at 05:12 PM.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using a function to deduct how much I need to add to a percentage
    By superboy in forum Excel General
    Replies: 4
    Last Post: 10-08-2013, 03:48 AM
  2. Replies: 2
    Last Post: 09-19-2013, 09:06 AM
  3. Deduct Percentage if Value In Between
    By TehNoob2010 in forum Access Tables & Databases
    Replies: 8
    Last Post: 08-16-2012, 06:27 AM
  4. [SOLVED] Percentage of amounts and profits of individual sales
    By lulubelleshell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-12-2005, 03:05 PM
  5. [SOLVED] Selecting amounts to display based on quantity
    By Ray Ash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2005, 07:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1