I'm relatively new to making formula and I need to create a formula for our bonus system. The info is as follows.

We earn a £25 bonus for every £500 in sales over a minimum sales achieved target of £7000. So for £7500 we get £25 for £8000 we get £50 and so on. Right through to £15000. I've set up a spreadsheet starting with a sales column b2 and a bonus column c2. I have tried one or two formula but am now getting no where any help would be much appreciated.