What that we've already offered doesn't work? I think this is the third
time you have posted this with slightly different weights!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"impression" wrote in message
...
I want to calculate the shipping costs for orders. I have a cell which
totals the weight. I have the shipping weights with corresponding rates.
I
want the "shipping cost" cell to look at the weight cell and calculate the
shipping rates for a range of weights. e.g. weight is 336 lbs and there
is a
rate for a range of 325-350lbs. This needs to be able to provide the rate
for a wide range of possible weights from 15 to 2,500lbs. Thanks for your
help