Results 1 to 6 of 6

How to include tier's in to a formula ?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-28-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    192

    Question How to include tier's in to a formula ?

    example, say I tell you, if you score 1000 points I will pay you in tiers.


    You score 1000,

    Tier 1 - For the first 150 pts I will pay 150 pts * 25
    Tier 2 - For the second 400 pts I will pay 400 pts* 30
    Tier 3 - For the remaining pts I will pay 450 pts*15



    My question is, regardless if 1000 points or less.. what forumla can I use to to include the tiers in my calculation?

    Excel sample attached to this post. Thank you

    edit to post: If it makes it easier I am ok even having to have 3 seperate formuals (per tier) , I can just add the the values to make my total. Although 1 formula would be nice.
    Attached Files Attached Files
    Last edited by eeps24; 12-07-2017 at 01:39 PM. Reason: edit added to bottom of post

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula help for a wealth management fee tier calculation
    By Marc.Cam in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-21-2023, 04:30 AM
  2. Creating a formula that will tier my data
    By soybn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-21-2017, 05:44 PM
  3. Cumulative Tier Formula using SUMPRODUCT
    By alewis1983 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-04-2016, 10:22 AM
  4. [SOLVED] Tier commission pay formula.
    By MARIOV1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-28-2015, 04:52 AM
  5. Replies: 17
    Last Post: 08-26-2014, 01:05 PM
  6. Hierarchy chart - Connect 1st tier to 3rd tier
    By bjcowen9000 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-22-2014, 05:24 AM
  7. [SOLVED] How do I create a 26 'tier' IF formula?
    By callum in forum Excel General
    Replies: 5
    Last Post: 10-23-2005, 12:05 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