+ Reply to Thread
Results 1 to 15 of 15

Tiered Pricing Help!

Hybrid View

Ashley12120 Tiered Pricing Help! 11-07-2017, 11:39 AM
shivya Re: Tiered Pricing Help! 11-07-2017, 11:41 AM
Sunny18pc Re: Tiered Pricing Help! 11-10-2017, 08:08 AM
shg Re: Tiered Pricing Help! 11-07-2017, 11:52 AM
Ashley12120 Re: Tiered Pricing Help! 11-07-2017, 12:33 PM
shg Re: Tiered Pricing Help! 11-07-2017, 12:35 PM
Ashley12120 Re: Tiered Pricing Help! 11-10-2017, 08:01 AM
shg Re: Tiered Pricing Help! 11-10-2017, 01:00 PM
Sunny18pc Re: Tiered Pricing Help! 11-10-2017, 08:21 AM
Ashley12120 Re: Tiered Pricing Help! 11-20-2017, 06:25 AM
JohnTopley Re: Tiered Pricing Help! 11-20-2017, 08:38 AM
Ashley12120 Re: Tiered Pricing Help! 11-22-2017, 10:59 AM
JohnTopley Re: Tiered Pricing Help! 11-22-2017, 11:04 AM
Ashley12120 Re: Tiered Pricing Help! 11-30-2017, 10:30 AM
The_Snook Re: Tiered Pricing Help! 11-30-2017, 11:10 AM
  1. #1
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Tiered Pricing Help!

    Welcome to the board.

    A
    B
    C
    D
    1
    Amt
    Fee
    delta
    2
    0
    0.85%
    0.85%
    C2: =B2 - N(B1)
    3
    250,000
    0.70%
    -0.15%
    4
    500,000
    0.60%
    -0.10%
    5
    1,000,000
    0.45%
    -0.15%
    6
    2,500,000
    0.25%
    -0.20%
    7
    5,000,000
    0.15%
    -0.10%
    8
    10,000,000
    0.10%
    -0.05%
    9
    10
    Amt
    Fee Amt
    11
    100,000
    850
    B11: =SUMPRODUCT((A11 > $A$2:$A$8) * (A11 - $A$2:$A$8) * $C$2:$C$8)
    12
    200,000
    1,700
    13
    500,000
    3,875
    14
    1,000,000
    6,875
    15
    2,000,000
    11,375
    16
    5,000,000
    19,875
    17
    10,000,000
    27,375
    18
    20,000,000
    37,375
    19
    50,000,000
    67,375
    20
    100,000,000
    117,375
    Entia non sunt multiplicanda sine necessitate

  2. #2
    Registered User
    Join Date
    11-07-2017
    Location
    London
    MS-Off Ver
    2010
    Posts
    6

    Re: Tiered Pricing Help!

    Thanks both for your help - I've attached the hopefully helpful spreadsheet with a couple of examples / desired results.

    Thanks
    Ashley
    Attached Files Attached Files

+ 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. [SOLVED] Tiered prorata pricing
    By danndoll in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 11-25-2019, 12:29 PM
  2. Tiered Pricing
    By mohammadsameja in forum Excel General
    Replies: 18
    Last Post: 07-01-2017, 07:28 AM
  3. [SOLVED] Tiered Pricing
    By Juan Bakal in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-02-2017, 08:51 AM
  4. [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
  5. [SOLVED] Tiered Pricing
    By unpuertomex in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-27-2012, 09:32 PM
  6. Tiered pricing
    By jimbojones82 in forum Excel General
    Replies: 1
    Last Post: 07-24-2012, 09:25 AM
  7. Tiered pricing issue
    By dea397732 in forum Excel General
    Replies: 3
    Last Post: 06-04-2010, 01:50 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