What I want to do is as follows:-

I have a set of fees I want to apply to prices depending on their values
I have may fees listed e.g. <1.00 = 10p, 1.01 to 4.99 = 20p 5.00 above = 30p

In one column I have a price (say £1.50) and in another I want the value to
be whichever applies to the price in the first column (in this case 20p).
Is this possible. I think it is the IF function. The auto calculating cell
needs to look to another cell for a value based on the initial price. If I
alter the fees say from 10p to 15p then this would need to update the auto
calculating cell.

Hopefully I've explained myself (?)

Thanks