One way ..

Assume weights are in A1 down

Put in say, B1:

=VLOOKUP(A1,{0,35;665,5.25;1000,4.75;2500,3;5000,2 .5;10000,1.95},2)

Copy B1 down
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"emerald_dragonfly" wrote in
message ...
I have a sliding price scale for transport based upon wgt. The greater
the
weight being transported the lower the cost per 100 lbs.
Example:
0 to 664 - flat rate of 35.00
665 to 999 - 5.25
1000 to 2499 - 4.75
2500 to 4999 - 3.00
5000 to 9999 - 2.50
10000 or greater - 1.95

How can I get Excel to automatically select the correct rate when I enter
the wgt of the shipment?