"adheit" wrote in message
...
No, I don't think so!!

I would say Yes, I do think so!

in your 1st post you said:
"adheit" wrote:

How do I set a value for a cell based on another cells value using
increment.

if cell b6 is V then cell b7 is Y based on the following interval:

V = 1-10 then Y = 5
V = 11-20 then Y = 10
V + 21-30 then Y= 15

The actual table to be used has 30 intervals.

My suggestion satisfies the illustration that you gave.

I assume from:
I have a table that I want to use to add on a fee based on an item cost in
another cell to calcute a retail price. The samle table is below:

$0-$4.99 then fee is $7.75
$5.00-$9.99 then fee is $8.25
$10.00-$25.00 then fee is $9.00

For example if the item cost is in cell 'b6' is $6.50 then Excel uses the
table above to add on the appropriate fee, or $8.25 to calculate a retail
price of $14.75

That your *real* data does not have a numerical relationship like the 1st
example. In that case to look up data in a table based on the value in
another cell checkout the VLOOKUP function in Help.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk