Here are the criteria

If the rate is 0.003515 and weight multiplied by rate < 11.50, then the charge is 11.50

If false, the rate is weight multiplied by rate

I can get that part but there are more criteria

If rate IS NOT 0.003515 and weight multiplied by rate < 15.00, then teh charge is 15.00

If false, the rate is weight multiplied by rate

I hope this isn't too confusing...Can anyone tell me how to set up such a formula? Thanks.

Excel User