Actually, you might want a vlookup. Check out
www.myexpertsonline.com/freedls/pricelist.xls and see what happens when you
hit the dropdown and choose a value. For yours, you'd be typing the value
in, I suppose.
Here's the skinny on vlookup:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Andy Roberts" wrote in message
...
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