+ Reply to Thread
Results 1 to 5 of 5

Tiered Pay Plan

  1. #1
    Registered User
    Join Date
    03-06-2024
    Location
    Massachusetts, USA
    MS-Off Ver
    Office 365
    Posts
    2

    Tiered Pay Plan

    I am having a hard time creating a tiered pay plan system. Multiple tiers, multiplied by the number entered. Whatever the number equals to in a range, it would be that dollar amount multiplied by the number. I included the tiered plan but cannot figure out how to do it in a formula. Is it even possible?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,831

    Re: Tiered Pay Plan

    You didn't enter your Excel Version. Please update that.
    This solution is for version MS365.
    You didn't enter any expected results, so I'm guessing a little. I assume you want a formula for the following cells:

    H10:
    =XLOOKUP(F10,$C$3:$I$3,$C$4:$I$4,,-1)

    I10:
    =XLOOKUP(G10,$C$5:$I$5,$C$6:$I$6,,-1)

    You can then copy these down to H12 and I12
    Attached Files Attached Files

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Tiered Pay Plan

    Ex2016 or older
    Do not change format.
    Try
    H10:
    Please Login or Register  to view this content.
    I10:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Quang PT

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Tiered Pay Plan

    In H11
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In I11
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  5. #5
    Registered User
    Join Date
    03-06-2024
    Location
    Massachusetts, USA
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Tiered Pay Plan

    Appreciate your help! Fixed my version, didn't realize that's the information that was needed.

    I'm not sure if I understand your comment on expected results? Are you referring to what I want my end result to be?

    After some digging within the forum, I realized I was searching wrong and found a few which includes the "Lookup" function you gave. I think this is exactly what I need.

    Thank you!

+ 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. Replies: 8
    Last Post: 03-24-2021, 05:47 AM
  2. Replies: 0
    Last Post: 03-26-2014, 05:23 AM
  3. [SOLVED] Tiered commission plan paid monthly
    By Cmar in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-08-2014, 02:15 AM
  4. MLM matrix plan plan 4x4 coding/formula
    By ncsvapi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2013, 08:23 AM
  5. Replies: 10
    Last Post: 05-11-2012, 02:14 AM
  6. Tiered Calculation
    By Derek Borckmann in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-07-2006, 12:20 AM

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