I am having trouble adding a maximum total price to this formula. I want the
calculated total to never exceed 465.00 How can I do that?

"emerald_dragonfly" wrote:

> 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?