+ Reply to Thread
Results 1 to 5 of 5

Tiered Pricing formula

Hybrid View

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

    Re: Tiered Pricing formula

    are you saying that for 301 - 700 they get 3 then 701 - 1200 they get 6 or they get 9, 3 for the first 700 and 6 for those below 1200 but above 700? Because depending on the answer there are two different formulas and results.
    this is one way for the first... =LOOKUP(A1,{0,301,701,1201,1801},{0,3,6,8,10})
    but a sumproduct or something else like an adjustment to this lookup would be the formula for the second.

    And, if you want to cover any issue with blanks then... =IF(A1="","",LOOKUP(A1,{0,301,701,1201,1801},{0,3,6,8,10}))
    And in both instances point the formula to where your data is by changing A1 to your data.
    Last edited by Sam Capricci; 10-25-2018 at 07:35 AM.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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. Tiered Pricing Formula Help
    By jbonsignore in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-11-2018, 09:39 AM
  2. Formula for Tiered Pricing
    By hanyyassin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2018, 06:39 AM
  3. [SOLVED] Tiered Pricing formula
    By egotrich in forum Excel General
    Replies: 11
    Last Post: 07-28-2017, 03:19 PM
  4. [SOLVED] Formula for Tiered Pricing
    By estallings85 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2017, 12:16 PM
  5. [SOLVED] Formula for tiered pricing
    By Unkilj in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-22-2017, 01:19 AM
  6. Tiered Formula for Pricing Rates
    By jweavs1994 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2016, 04:44 PM
  7. [SOLVED] Formula for tiered pricing
    By riaface in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-16-2014, 12:38 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