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.