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.

Thanks for your help

Try:

CEILING(V,10)/2

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


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

Thanks for your help

For further clarification, V = range for Y i.e if cell b6 is within a range
of 1-10 then y=5 etc

"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.

Thanks for your help

Isn't that what the formula I suggested does?

=CEILING(B6,10)/2

where B6 is the 'V' that you referred to returns 5 for any value in B6 from
1 - 10, 10 for any value 11 - 20. 15, for 21 - 30 etc.
--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk


"adheit" wrote in message
...
For further clarification, V = range for Y i.e if cell b6 is within a
range
of 1-10 then y=5 etc

"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.

Thanks for your help

No, I don't think so!!

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

Thanks for you help


"Sandy Mann" wrote:

Isn't that what the formula I suggested does?

=CEILING(B6,10)/2

where B6 is the 'V' that you referred to returns 5 for any value in B6 from
1 - 10, 10 for any value 11 - 20. 15, for 21 - 30 etc.
--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk


"adheit" wrote in message
...
For further clarification, V = range for Y i.e if cell b6 is within a
range
of 1-10 then y=5 etc

"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.

Thanks for your help

"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