Excel - IF Function Problem - Expert Solution

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
User 30/11/2017 - 08:18
Hi
Excelchat Expert 30/11/2017 - 08:18
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
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
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
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
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
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.

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.