Results 1 to 6 of 6

Thread: Excel - volume discounts

  1. #1
    Junior Member
    Join Date
    Jan 2018
    Location
    Amatikulu
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel - volume discounts

    Hi All

    Any idea what formula I would use if wanting to calculate a percentage volume discount...

    E.g if cell A1 shows total of items -

    100 - 500 items 5% discount
    501 - 700 7.5% discount
    701 - 900 10% discount


    Many thanks

    Catherine

  2. #2
    Full Member
    Join Date
    Dec 2016
    Location
    Cape Town
    Posts
    38
    Thanks
    2
    Thanked 6 Times in 5 Posts
    Adapt as required:

    Click image for larger version. 

Name:	vlookup.JPG 
Views:	238 
Size:	21.4 KB 
ID:	7063

  3. #3
    Junior Member
    Join Date
    Jan 2018
    Location
    Amatikulu
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the reply but my formula doesnt seem to work for the range.. so it will find 100, 500 but wont fine 150...

  4. #4
    Full Member
    Join Date
    Dec 2016
    Location
    Cape Town
    Posts
    38
    Thanks
    2
    Thanked 6 Times in 5 Posts
    You need to have the "TRUE" value at the end of the formula to search for an approximate value in your lookup table.

  5. #5
    Junior Member
    Join Date
    Jan 2018
    Location
    Amatikulu
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sorry I have just seen that you had True... at the end!!

  6. #6
    Junior Member
    Join Date
    Jan 2018
    Location
    Amatikulu
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Works like a charm thank you! I could have saved a lot of time if I had asked earlier

Similar Threads

  1. video volume
    By wynn in forum Technology Forum
    Replies: 3
    Last Post: 13-Nov-15, 11:17 AM
  2. PASTEL V11 POS DISCOUNTS
    By Coolblue in forum Accounting Forum
    Replies: 0
    Last Post: 25-Feb-14, 11:52 AM
  3. Voyager travelling miles/discounts ?
    By HR Solutions in forum General Business Forum
    Replies: 6
    Last Post: 26-Jul-13, 09:15 AM
  4. [Question] Trade discounts and rebates
    By Loyyd in forum Accounting Forum
    Replies: 2
    Last Post: 24-Mar-13, 04:33 PM
  5. OSCARS - Internet Wars - Volume 1
    By Darkangelyaya in forum General Chat Forum
    Replies: 16
    Last Post: 18-Mar-13, 11:54 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

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