Hello everyone. I'm a newbie here and have searched the New Users
threads with no luck.

I have a small sales business and have created a workbook to figure
pricing. The problem I'm having is calculating shipping costs. We use
UPS and they charge by the pound. I can total the weight of all items
on an order but I can't figure out how to make the worksheet find the
shipping costs based on the weight totals.

For example, the freight weights a
Weight, lbs Price
Under 3 5.95
3 - 6.9 6.85
7 - 13.9 7.85
14 - 23.9 8.90
24 - 39.9 0.35 per lb
40 - 59.9 0.31 per lb
and so on down to
Over 1000 0.24 per lb.

I've tried some of the VLOOKUP formulas in this forum without luck. I
just don't know what I'm doing.

Can someone help?

Thank you very much,

Lynn


--
LPJR
------------------------------------------------------------------------
LPJR's Profile: http://www.excelforum.com/member.php...o&userid=29138
View this thread: http://www.excelforum.com/showthread...hreadid=488975