**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.*