Question description:
This user has given permission to use the problem statement for this
blog.
5 Team Member solved different no of cases and gained good incentive however minimum case solved condition apply - So does not matter how much incentive they earned if minimum number of cases are not solved then they will get the fixed incentive of $3000. Will give you an example.
Solved by G. J. in 25 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
30/11/2017 - 08:18
Welcome to excel got it pro
Excelchat Expert
30/11/2017 - 08:18
I'm here to help you today.
User
30/11/2017 - 08:18
Hi
Excelchat Expert
30/11/2017 - 08:18
Please show the example
User
30/11/2017 - 08:18
ok
Excelchat Expert
30/11/2017 - 08:19
Better yet please share the file if you don't have any confidentiality problem.
User
30/11/2017 - 08:19
Did you get it
Excelchat Expert
30/11/2017 - 08:19
hmm
User
30/11/2017 - 08:20
Person who solved 70 cases will get his 6000
User
30/11/2017 - 08:20
However Domnic and Mark will get fixed incentive as minimum cases solved less then 50
Excelchat Expert
30/11/2017 - 08:21
=if(D3<50,3000,E3)
Excelchat Expert
30/11/2017 - 08:21
this formula will give you the desired result. I've wrote it on column G.
User
30/11/2017 - 08:21
Can we club this formula with another formula
Excelchat Expert
30/11/2017 - 08:22
yeah, but it depend on what you want.
User
30/11/2017 - 08:24
Please calculate the incentive as per slabs given and in the same cell apply minimum case's condition as well
Excelchat Expert
30/11/2017 - 08:24
what will you be using? excel or google sheet?
User
30/11/2017 - 08:25
Google sheet
Excelchat Expert
30/11/2017 - 08:25
ok
Excelchat Expert
30/11/2017 - 08:29
can you flip the incentive table in descending order, that will make the formula short.
User
30/11/2017 - 08:29
You can do it
User
30/11/2017 - 08:33
Not worked
Excelchat Expert
30/11/2017 - 08:33
still working on it.
User
30/11/2017 - 08:33
ok
Excelchat Expert
30/11/2017 - 08:33
I will let you know when I'm finished.
User
30/11/2017 - 08:33
ok
Excelchat Expert
30/11/2017 - 08:35
now I'm done. Please check it.
User
30/11/2017 - 08:36
Let me check
Excelchat Expert
30/11/2017 - 08:36
sure.
Excelchat Expert
30/11/2017 - 08:36
take your time.
User
30/11/2017 - 08:36
Show me the formula - It is working
User
30/11/2017 - 08:36
got it
Excelchat Expert
30/11/2017 - 08:36
=IF(E12<50,3000, vlookup(F12,$A$13:$B$16,2,true))
Excelchat Expert
30/11/2017 - 08:37
hmm, what do you think of my service?
Excelchat Expert
30/11/2017 - 08:37
anything else?
User
30/11/2017 - 08:37
This is awsome
User
30/11/2017 - 08:38
Please wait
User
30/11/2017 - 08:38
let me apply on my work station
Excelchat Expert
30/11/2017 - 08:38
I'm here.
Excelchat Expert
30/11/2017 - 08:39
A friendly reminder I would appreciate your feedback on my performance. once you press the "end session" button to close the session you will be asked to rate me.
User
30/11/2017 - 08:39
wait
Excelchat Expert
30/11/2017 - 08:39
hmm, take your time.
User
30/11/2017 - 08:43
It is working
User
30/11/2017 - 08:43
Great
User
30/11/2017 - 08:43
You all people are just awsome
User
30/11/2017 - 08:43
I love you guys
Excelchat Expert
30/11/2017 - 08:43
Well thank you for visiting us.
Excelchat Expert
30/11/2017 - 08:43
We take pleasure in helping people.
Excelchat Expert
30/11/2017 - 08:43
Have a great day!
Excelchat Expert
30/11/2017 - 08:43
And please close the session
User
30/11/2017 - 08:43
God bless you all
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.