• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Incentive structure - incremental basis

Krishnan

New Member
Hi there!

Working on an incentive structure and looking for some help with formula around this.
Assuming IF AND should work here or would this be easier with look up?

Attached is file with the criteria.

Cheers!
K
 

Attachments

  • Incentive _ Working File.xlsb
    17.9 KB · Views: 3
Worked this out....thanks! Sharing the solution for good order
 

Attachments

  • Formula for Campaign.xlsx
    15.8 KB · Views: 5
Last edited:
I have included a solution that conforms to my way of using Excel. It is far from standard and I make no attempt to achieve compatibility with solutions other than 365 or Excel 2021.
Code:
= MAP(threshold,limit,percentage,
      LAMBDA(th,lt,p, p * MAX(MIN(eligibleAmt,lt)-th,0)) )
Out of curiosity, your result for eligible amounts >100,000 are not what I would expect.
78389
 

Attachments

  • Formula for Campaign (1).xlsx
    11.8 KB · Views: 6
Last edited:
Hi Peter - the codes are a bit of a challenge for me...will surely dig deep to understand.
On the result for >100,000 - the intention was to get the team to push past the target for the full 3% (hence inconsistent with the scale on the other thresholds)
-K
 
Back
Top