Hi Guys

I am new to Excel and would like to know if anyone can give me advice on creating a formula, within a cell.

Basically I have to calculate a sliding scale % reduction for every £60 after £6000 and up to £12000. ie at £6060 a 99% reduction is gained, at £6120 it is 98%, £6180 it is 97%. At the other end of the scale £11,940 is 1%, £11,880 is 2%, £11,820 is 3% etc. I need the calculation to work reflect 0.5% ie £6030 would be 99.5%, £11,970 would be 0.5%.

Could anybody please give me a formula to copy & paste or advise if this is possible?

Any help would be really appreciated!