Question description:
This user has given permission to use the problem statement for this
blog.
I want a formula to calculate commission based on if an accumulation of months has met a threshold, I have one that is (IF(SUM(Accumulation)
Solved by O. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
11/08/2017 - 04:21
For instance, a sample data we can work on?
User
11/08/2017 - 04:21
I can add some data
User
11/08/2017 - 04:25
That is how I have it now, but I want the 600 to be split between the fee so 500 gets the 20% and the 100 only gets the 5
User
11/08/2017 - 04:25
And I want it to be based off the threshold input so if it changes
Excelchat Expert
11/08/2017 - 04:27
So, if I am getting this correctly, it is 500+750+100(from the 600)
Excelchat Expert
11/08/2017 - 04:27
Which fulfilled the threshold?\
User
11/08/2017 - 04:28
Yes
User
11/08/2017 - 04:28
But I want it to be flexible so I change the threshold to 1450 it would take 200 times the 5%
Excelchat Expert
11/08/2017 - 04:28
So anything after the third value is also going to get the 20%?
User
11/08/2017 - 04:29
Yes anything above the thershold gets the 20%
Excelchat Expert
11/08/2017 - 04:29
Entering Explanation Phase
Excelchat Expert
11/08/2017 - 04:30
Alright, so for your requirement, what I am thinking is to add some cells which will handle some calculations.
Excelchat Expert
11/08/2017 - 04:30
Let me try something first
Excelchat Expert
11/08/2017 - 04:38
Alright, so from here, we can create formulas which will take into account the part where the collections went higher than the threshold.
Excelchat Expert
11/08/2017 - 04:39
You can maintain the same formula that you have, but we can add a modification.
Excelchat Expert
11/08/2017 - 04:40
If the timer runs out, please feel free to repost and ask for Exp_Oly.
User
11/08/2017 - 04:40
Ok
Excelchat Expert
11/08/2017 - 04:40
But we can continue oin this link for now
Excelchat Expert
11/08/2017 - 04:40
https://docs.google.com/spreadsheets/d/1Hft3XTEDgT1yAYqTor8Ep_IrPkFLErO_U517EBt0G5w/edit#gid=0
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
