Set value for a cell basd on another cells value using an incremen

A

adheit

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
 
A

adheit

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

Sandy Mann

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
[email protected]
Replace@mailinator with @tiscali.co.uk
 
A

adheit

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
[email protected]
 
S

Sandy Mann

adheit said:
No, I don't think so!!
Click to expand...

I would say Yes, I do think so!

in your 1st post you said: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
Click to expand...

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
[email protected]
Replace@mailinator with @tiscali.co.uk
 
Top