+ Reply to Thread
Results 1 to 5 of 5

Need help with a Different price - Different discount formula

  1. #1
    Registered User
    Join Date
    03-01-2020
    Location
    Miami, Florida
    MS-Off Ver
    2020
    Posts
    2

    Need help with a Different price - Different discount formula

    Hi Everyone
    I am looking for someone to help me with a formula to achieve the following.

    I am a printing company. I sell stickers. what I am trying to have a formula for figure pricing.
    the more stickers my customer buys the more discount they get.

    for example:
    2" X 2" stickers
    50 stickers = $58
    100 stickers = $70 - 40% discount
    200 stickers = $92 - 60% discount
    300 stickers = $112 - 68% discount
    500 stickers = $147 - 75% discount
    1,000 stickers = $225 - 81% discount
    2,000 stickers = $225 - 84% discount
    3,000 stickers = $225 - 86% discount
    5,000 stickers = $225 - 88% discount
    10,000 stickers = $225 - 90% discount

    if the size of the stickers changes, the price, and the discount percentages changes as well.

    you can see a sample of a company that has achieved it.
    ___stickermule.com/products/kiss-cut-stickers___
    I am creating a website and I would like to do achieve the same. So I am looking for an excel formula.
    I have tryed but cant figure it out. I really need help

    I will appreciate if you can help me with this. I am also willing to monetary repay anyone that can help me.

    Best regards,
    Stuart

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Need help with a Different price - Different discount formula

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Quang PT

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Need help with a Different price - Different discount formula

    not given an example, I'm attaching how I would approach it.
    first, you didn't really say if you were altering the amounts for the stickers based on numbers in between, such as an order for 75 so I am assuming it is that you just offer those quantities and those rates so if you need 2500 you need to buy 3000.
    I used a vlookup with TRUE in case you do have numbers that vary. Adjust it as necessary.
    Attached Files Attached Files
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Registered User
    Join Date
    03-01-2020
    Location
    Miami, Florida
    MS-Off Ver
    2020
    Posts
    2

    Re: Need help with a Different price - Different discount formula

    Thank you for your reply. I really appreciate. I have 4 to 5 set sizes but will also have the option to custom size. same thing with quantities. will have 6-7 set quantities but also have the option to custom quantities.Attachment 665533
    if you see in this picture you can see what I mean as well as where you can find a working site where I found it.
    The way this website does it is the following:
    when you choose a size
    you get a price for quantities
    the higher the quantities the more discount percentage you get.

    but every size you choose the prices per quantities are different as well as the discount percentage.
    I think they either do the math by the square inch or a formula that I cant seem to find.

    I really appreciate your help.

  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Need help with a Different price - Different discount formula

    Based on Sambos work

    Formula for C2
    =VLOOKUP($B$2,$E$2:$Z$200,MATCH(A2,1:1,0)-4,TRUE)

    I have put data validation in A2.
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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. List price and Discount Manipulator to Get the Target Net price
    By xoblox in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2016, 03:52 PM
  2. Price Per Unit in a Table for a Fixed Incremental Price Discount
    By natkoy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2016, 03:51 AM
  3. Voiume price discount
    By andymuggwump in forum Excel General
    Replies: 1
    Last Post: 12-07-2014, 07:31 AM
  4. how to count discount price
    By vivek_work in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-24-2013, 04:47 PM
  5. Replies: 2
    Last Post: 05-07-2007, 12:12 AM
  6. Replies: 6
    Last Post: 10-12-2005, 03:05 PM
  7. [SOLVED] formula for - price times discount times tax = final price
    By anton in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-12-2005, 09:05 AM

Tags for this Thread

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