Please help calculating tiered bonus for multiple employees

Hi All,

I have what is probably a simple problem, but one which I cant solve. I need to calculate employee bonuses as follows

Minimum sales bonus per sale
30 £10.00
40 £20.00
60 £25.00

So if someone made 70 sales they would get 30 x 0 plus 10x£10 plus 20x£20.00 plus 10 x £25.00 for a total of £750.00. I can make this work using separate arguments for each level, but only for one person. I suspect the answer is to do with a lookup table but cant figure it out. Can anyone help with this?

Many thanks,

Maybe this, assuming the sales count is in A1

=IF(A1>60,25*(A1-60))+IF(A1>40,20*MIN(A1-40,20)) +IF(A1>30,10*MIN(A1-30,10))

Thanks so much to Mr Ice and Glenn Kennedy. Both solutions work perfectly and I now see why my own didn't-I was trying to combine a lookup table with similar although much more lengthy arguments to Mr Ice. I'm going to learn a lot from analysing both solutions later.

Thanks Again!