I have 4 columns (Weight, Rate, Min Charge, Max Charge). I am looking
for a formula that will return the correct charge whether it be the
Weight*Rate calculation, Min Charge or the Max Charge.

If the Weight*Rate is less than the Min Charge then return the Min
Charge.
If the Weight*Rate is greater than the Max charge then return the Max
Charge.
If the Weight*Rate is between the Min Charge and the Max Charge return
the Weight*Rate calculation.

Sample Data:

Weight Rate Min Max
1280 $4.70 $89.00 $225.00
6598 $4.50 $124.00 $270.00

(1280 is in cell A2)

Thanks for your help!