Results 1 to 4 of 4

Formula for Tiered Pricing

Threaded View

  1. #1
    Registered User
    Join Date
    07-25-2017
    Location
    NJ
    MS-Off Ver
    2016
    Posts
    3

    Formula for Tiered Pricing

    Hello,

    I was hoping someone could assist me with the following problem. I am trying to work on a formula that will assist me with billing for tiered pricing. The tiers and pricing are as followed -

    up to 10,000 - 0.20 cents per record
    10,001 - 50,000 - 0.10 cents per record
    50,001-100,000 - 0.05 cents per record
    100,001 - 500,000 - 0.03 cents per record
    500,001-1,000,000 - 0.02 cents per record

    I have been trying to utilize the sum product formula which is as followed - =SUMPRODUCT(--(O2>{0,10000,40000,50000,400000,500000}),--(O2-{0,10000,40000,50000,400000,500000}),{0,0.2,-0.1,-0.05,-0.03,-0.02})-P2

    however I am off by 1k.

    I have also attached the spreadsheet I am working on which gives the amount of records per month. Any help will be appreciated
    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 and variable amount of transactions
    By dallen805 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-22-2017, 01:37 PM
  2. [SOLVED] Formula for tiered pricing
    By Unkilj in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-22-2017, 01:19 AM
  3. [SOLVED] Formula to Calculate Tiered Pricing
    By KAYPAR2003 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-01-2017, 03:23 PM
  4. Tiered Formula for Pricing Rates
    By jweavs1994 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2016, 04:44 PM
  5. [SOLVED] Formula for tiered pricing
    By riaface in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-16-2014, 12:38 PM
  6. Replies: 6
    Last Post: 01-11-2014, 01:47 PM
  7. HELP required - cannot create formula to auto calculate tiered pricing...
    By dcj1606 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-18-2013, 05:16 PM

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