Question description:
This user has given permission to use the problem statement for this
blog.
if actual sales higher than quota pay 5% if actual sales lower than quota pay 2%, how do I write this formula?
Solved by S. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
10/08/2018 - 02:16
Hello
Excelchat Expert
10/08/2018 - 02:17
Welcome to excel gotit pro
Excelchat Expert
10/08/2018 - 02:17
Can you show me a few example data please?
Excelchat Expert
10/08/2018 - 02:20
Hello, are you there?
Excelchat Expert
10/08/2018 - 02:23
Hello!
Excelchat Expert
10/08/2018 - 02:27
What I understand from description is that there is a quote column and there is a actual sales column. Now you want to pay 4% if actual is greater than quote's otherwise pay 2%.
Excelchat Expert
10/08/2018 - 02:28
I've added some sample data on the preview window and and write the formula for it. The data is in column A and B.
User
10/08/2018 - 02:29
wWhere is the formula??
Excelchat Expert
10/08/2018 - 02:30
Its nice to get your response. I had some confusing hence asked for data. I didn't finish writing the formula yet.
Excelchat Expert
10/08/2018 - 02:30
=IF(B2>A2,B2*4%,B2*2%) here is the formula assuming you want 4% and 2% of actual sales.
User
10/08/2018 - 02:31
Yes this is what i need, thank you very much!!
Excelchat Expert
10/08/2018 - 02:31
I'm glad that you approve.
Excelchat Expert
10/08/2018 - 02:31
Let me know if you have any question.
Excelchat Expert
10/08/2018 - 02:36
The chat will end now.
Excelchat Expert
10/08/2018 - 02:36
Have a great day!
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.
