# Calculate Shipping Charges

## Recommended Posts

I have a vendor who has defined their shipping charges thusly:

< 1lb. = 8.99

1.01 Pounds to 10.00 Pounds = 8.99+.50 per pound

10.01 Pounds or more = 9.99 + .40 per pound

I have a field called Billable weight (in Lbs.) which is essentially just the dimensional weight pre-caclulated. What formula would I use to calculate shipping charges based on my billable weight field?

Edited by OneStop

##### Share on other sites

The formula would be almost exactly what you wrote:

```Case (
BillableWeight ≤ 1 ; 8.99 ;
BillableWeight ≤ 10 ; 8.99 + 0.5 * BillableWeight ;
9.99 + 0.4 * BillableWeight
)```

Note that your definition does not cover the case where the weight is exactly 1 pound.  Here we are assuming it is included in the first instance.

##### Share on other sites

Worked perfectly! Thank you.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

• ### Who Viewed the Topic

×
×
• Create New...