Results 1 to 9 of 9

Tiered Pricing

Threaded View

  1. #1
    Registered User
    Join Date
    02-04-2020
    Location
    Baltimore, MD
    MS-Off Ver
    O365
    Posts
    6

    Tiered Pricing

    Looking for an elegant way to handle tiered pricing.

    In other words, if you buy <10, your price is $x. But if you buy 11-25, the price is $y, and if you buy 26-50, the price is $z.

    This seems to be pretty simple, but doing it is taking on the form of nested IFs.

    =IF(A1<11,10,IF(A1<26,9,IF(A1<51,8)))

    Something like that. The problem is that the list is rather long, and I'd much rather have a way to look it up instead of having to fix a bunch of nested IFs every time the prices change. What I'd prefer would be a lookup table, where I can say something like, "If the value is between C1:C20 to D1:D20, then the price is E1:E20" (with each individual lookup being on the same row.)

    I think it should be do-able through some sort of VLOOKUP, but I don't know how to do it.

    Any thoughts?
    Last edited by d0ughb0y; 02-04-2020 at 01:41 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with a Tiered Pricing Calculator?
    By godawgs17 in forum Excel General
    Replies: 5
    Last Post: 12-14-2018, 03:27 AM
  2. [SOLVED] Tiered Pricing Help!
    By Ashley12120 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-30-2017, 11:10 AM
  3. Tiered Pricing
    By mohammadsameja in forum Excel General
    Replies: 18
    Last Post: 07-01-2017, 07:28 AM
  4. [SOLVED] Tiered Pricing
    By Juan Bakal in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-02-2017, 08:51 AM
  5. [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
  6. [SOLVED] Tiered Pricing
    By unpuertomex in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-27-2012, 09:32 PM
  7. Tiered pricing
    By jimbojones82 in forum Excel General
    Replies: 1
    Last Post: 07-24-2012, 09:25 AM

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