How to set mulplication of cells upto a limit

[Subroda]

Sorry if title is inaccurate I did not know how to describe it. What I mean is how do you make it so say for example you get paid £5 for every sale until 5 sales then each sale is worth £8 until 8 sales where they all become worth £10 each. For example:

1 sale = £5
4 sales therefore = £20
BUT 5 sales = £40 (because once you hit the 5th sale all the sales are worth £8 instead of £5)

etc. I'm hoping there is a way to do this on excel as im doing wages sheets for staff.

Thanks

 

[Dreadknight Nasus]

Sorry if title is inaccurate I did not know how to describe it. What I mean is how do you make it so say for example you get paid £5 for every sale until 5 sales then each sale is worth £8 until 8 sales where they all become worth £10 each. For example:

1 sale = £5
4 sales therefore = £20
BUT 5 sales = £40 (because once you hit the 5th sale all the sales are worth £8 instead of £5)

etc. I'm hoping there is a way to do this on excel as im doing wages sheets for staff.

Thanks

If your number of sales is in cell A1, then you could put this formula into cell B1:

 =IF(A1 <5, A1*5, IF(A1>7,A1*10,A1*8))

 

[Subroda]

If your number of sales is in cell A1, then you could put this formula into cell B1:

 =IF(A1 <5, A1*5, IF(A1>7,A1*10,A1*8))

What i need exactly is: When i enter the number of pitches one of my staff get a week i want to be able to simply put the number of pitches they get a day. So say mployee A get

Day 1 - 1 pitch
Day 2 - 0
Day 3 -3 pitches
Day 4 - 2 pitches
Day 5 - 3 pitches

When i enter the values in the system each day for first three days he got 4 pitches (so they are worth £5 each) but on day 4 he got 2 more meaning each of the 6 pitches is now worth £8 and then day 5 when i put it in the employee has now got 9 pitches meaning each of the 9 is worth £10. What code would i use for that and would i put the code in each cell?

I hope that makes sence.

Regards
Subroda

 

[Dreadknight Nasus]

What i need exactly is: When i enter the number of pitches one of my staff get a week i want to be able to simply put the number of pitches they get a day. So say mployee A get

Day 1 - 1 pitch
Day 2 - 0
Day 3 -3 pitches
Day 4 - 2 pitches
Day 5 - 3 pitches

When i enter the values in the system each day for first three days he got 4 pitches (so they are worth £5 each) but on day 4 he got 2 more meaning each of the 6 pitches is now worth £8 and then day 5 when i put it in the employee has now got 9 pitches meaning each of the 9 is worth £10. What code would i use for that and would i put the code in each cell?

I hope that makes sence.

Regards
Subroda

So you're just using the sum of all the sales they made in a week, right? So if you put the numbers in cells A1-A5, in cell A6 you could put the formula

=IF(sum(A1:A5) <5, sum(A1:A5)*5, IF(sum(A1:A5)>7,sum(A1:A5)*10,sum(A1:A5)*8))

(just replace the A1 with sum(A1:A5))