I am trying to set up a formula for a column of cells but I don't know how
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
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