Excel - IF Function Problem - Expert Solution

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
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
Excelchat Expert 11/08/2017 - 04:40
But we can continue oin this link for now
Excelchat Expert 11/08/2017 - 04:40

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc