Thanks for your help the other day, as sales managers do this one has put a real spanner in the works.

I have these formulas running in my spreadsheet but now he wants to add an accelerator bonus to the formula.

=IF(D21="","",IF(D21<1000,100,D21*10%))
=IF(D22="","",IF(D22<1000,100,D22*10%))
=IF(D23="","",IF(D23<1000,100,D23*10%))
=IF(D24="","",IF(D24<1000,100,D24*10%))
=IF(D25="","",IF(D25<1000,100,D25*10%))
=IF(D26="","",IF(D26<1000,125,D26*12.5%))
=IF(D27="","",IF(D27<1000,125,D27*12.5%))
=IF(D28="","",IF(D28<1000,125,D28*12.5%))
=IF(D29="","",IF(D29<1000,150,D29*15%))
=IF(D30="","",IF(D30<1000,150,D30*15%))
=IF(D31="","",IF(D31<1000,150,D31*15%))

So from the above when they enter a profit figure in cell D21 it gives them £100 if the profit is less than £1,000 and if greater it gives them 10% of the profit. After number 5 is sold they get 12.5% and so on up to 15%. Does anyone know how I can add to the above formulas so that once deal 5 is done it adds an extra 2.5% and applies it to the first 5 formulas, Then once deal 9 is done it applies 5% to the previous 8 deals done.