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