Results 1 to 2 of 2

Formula for Tiered pricing with various pricing matrix

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2020
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    1

    Formula for Tiered pricing with various pricing matrix

    Hey,

    I am trying to work on calculating revenue based tiered pricing which on various types of pricing matrix. Please help me what formula will help me calculate this.

    Pricing Modal Volume Price
    Flat Pricing Any volume 0.15
    Step Basis 0-1000 0.15
    1001-2000 0.14
    2001-10000 0.13
    10001 - Above 0.11
    Slab Basis %age discount 0-1000 0.15
    0-2000 0.15-10%
    0-3000 0.15-15%
    3000 - Above 0.15-20%
    Volume based free units 1000 0.15
    1001-2000 0.15 100 Units free
    2001-3000 0.15 200 units free

    Looking for help in terms of defining formula without using VBA.
    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. Tiered Pricing formula
    By ahmedrz81 in forum Excel General
    Replies: 4
    Last Post: 10-25-2018, 12:09 PM
  2. Tiered Pricing Formula Help
    By jbonsignore in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-11-2018, 09:39 AM
  3. Formula for Tiered Pricing
    By hanyyassin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2018, 06:39 AM
  4. [SOLVED] Tiered Pricing formula
    By egotrich in forum Excel General
    Replies: 11
    Last Post: 07-28-2017, 03:19 PM
  5. [SOLVED] Formula for Tiered Pricing
    By estallings85 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2017, 12:16 PM
  6. [SOLVED] Formula for tiered pricing
    By Unkilj in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-22-2017, 01:19 AM
  7. [SOLVED] Formula for tiered pricing
    By riaface in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-16-2014, 12:38 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