Thanks Ron

I may be wrong here but will your suggestion only work with specific prices
i.e. if the cost is £1 it will return X etc. What if the price is 75p?

What I want to do it say that any price less than £1 is X, between £1.01 and
£5.00 is Y and above £5.00 is Z.

Thanks


"Ron Rosenfeld" wrote in message
...
On Sat, 25 Jun 2005 15:44:08 +0000 (UTC), "Andy Roberts"

wrote:

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


Probably a VLOOKUP formula would let you more easily alter your fees, in
the
future.

For now set up a two column table named 'tbl'

0 10p
1 20p
5 30p

Then use the formula:
=VLOOKUP(price,tbl,2)

(price and tbl can be replaced by cell references)




--ron