Help required with formula

[mcdabs1986]

Hi,

I need help with a formula that works out a commission based on the number of sales you get. The ount of commission you get is tiered dependant on number of sales

1-4 sales = £5 each
5-9 sales = £7.50 each
10+ sales = £12.50 each

I have tried using a formula with IF statements but that only calculates the sales up to 4 and over 10. Can anyone help please?

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this, copied down, what you mean? If not, more details please.

Excel Workbook
	A	B
1	Sales	Commission
2	2	10
3	13	162.5
4	8	60
5	10	125
6	5	37.5
7	0	0
8	200	2500
Commission

 

[mcdabs1986]

Hi,

The examples you have given are correct. I will give this a try and let you know if it works.

Thanks.

 

[Peter_SSs]

You're welcome. Post back with specific examples & expected results if it does not do what you want.

 

[mcdabs1986]

That worked perfectly thank you

 

[Peter_SSs]

That worked perfectly thank you

Good to hear. Thanks for the follow-up.