Less than = x, More than = y

Hello -

A colleague has asked me to try and find out if it is possible to automate his spreadsheet to do the following.

In the initial column he wants to enter a figure (£) and he wants the next column to fill with the required % fee.

So the initial column he will enter any figure, he wants anything 0-10,000 to = 4.5% and anything 10,000 + to = 7.5%

I don't know any way to do this, can anyone help?

Any advice is much appreciated.

Thanks for that, I've tried applying this to a cell but it tells me there's something wrong...I'm really not great at this.

Any idea how I can apply this in practice?