Results 1 to 4 of 4

Dynamic Tiered Pricing Table

Threaded View

  1. #1
    Registered User
    Join Date
    07-14-2020
    Location
    New York
    MS-Off Ver
    365
    Posts
    2

    Dynamic Tiered Pricing Table

    I'm new to the community and was trying to find a solution for a tiered pricing module. I see a few solutions but they tend to be hard-coded with the tiers and rates directly in the formula. I'm curious if it can be dynamic where I can change the rates, or tiers in the cells without having to redo the formula. When I change a number to reference the CELL in some of the examples they no longer work.

    It looks like SUMPRODUCT is the right answer but I've seen a couple using MIN and MAX but those seem rather convoluted.

    One solution was close but didn't work for quantities over the max number. In other words any number over "26" produced the same result.

    I've attached the worksheet with some example results (calculated manually) and was hoping someone would be able to help us out. It seems the formula works based on the difference so I added that column as well.

    The Tiers:
    First site = $2,500
    2 through 5 = 1,000
    6 through 10 = 750
    11 through 25 = 500
    26 + = 250

    The reason we want it dynamic is we may want to change the second tier from $1,000 to $1,250 (or 850) just to see how that impacts a deal.

    Any help would be appreciated.

    Regards,

    Mike
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for Tiered pricing with various pricing matrix
    By kunaltalreja in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2020, 11:37 AM
  2. [SOLVED] Tiered Pricing
    By d0ughb0y in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-04-2020, 01:43 PM
  3. [SOLVED] Tiered Pricing Help!
    By Ashley12120 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-30-2017, 11:10 AM
  4. Tiered Pricing
    By mohammadsameja in forum Excel General
    Replies: 18
    Last Post: 07-01-2017, 07:28 AM
  5. [SOLVED] Tiered Pricing
    By Juan Bakal in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-02-2017, 08:51 AM
  6. [SOLVED] Trying to add tiered pricing to a CSV
    By rbsteve in forum Excel General
    Replies: 8
    Last Post: 07-01-2015, 04:57 AM
  7. [SOLVED] Tiered Pricing
    By unpuertomex in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-27-2012, 09:32 PM

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