+ Reply to Thread
Results 1 to 15 of 15

Tier incentive - will be automatically calculated based on Tier

Hybrid View

  1. #1
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,492

    Re: Tier incentive - will be automatically calculated based on Tier

    Or this:

    =D22*LOOKUP(D22,{0,25000,35001,45001,55001,66001,77001,88001},{0,0.12,0.15,0.17,0.19,0.2,0.22,0.24})

    and then:

    =D23+D22
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  2. #2
    Registered User
    Join Date
    05-05-2024
    Location
    riyadh
    MS-Off Ver
    MS365 Version 2403
    Posts
    81

    Re: Tier incentive - will be automatically calculated based on Tier

    thank you Ms. ALiGW ,, its solved . thanks also for the effforts Mr. Glenn, I appreciate a lot .

+ 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. Cumulative tier Discount Formula with Max Discount per tier
    By Celtic- in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-06-2022, 11:36 PM
  2. Help with Commission Calculation based on accelerator and attainment tier
    By pantsonfire123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2021, 11:49 AM
  3. I need help with Tier based commission calculations
    By ForestDeGump in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-08-2020, 10:16 AM
  4. [SOLVED] Electirc Bill Formula with Tier based pricing help
    By hotzpacho in forum Excel General
    Replies: 4
    Last Post: 02-21-2015, 05:43 PM
  5. 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
  6. create, name and fill new worksheets based on a two tier question
    By Mause77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2014, 03:10 AM
  7. Replies: 2
    Last Post: 03-28-2006, 06:13 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