View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mark Toulson Mark Toulson is offline
external usenet poster
 
Posts: 4
Default How do I create a formula that calculates shipping costs?

I would kike to calculate shipping costs before I receive the invoice from
the supplier. The costs are based on destination and weight of the shipment.
For example, I may have one shipment to Austria weighing 2.5 kilos, and
another weighing 25 kilos. The rates are calculated in increments of half
kilos up to 5 kilos, then after that I have a basic charge of 5 kilos plus a
reduced 0.5 kilo rate.

Can anyone help?

Thanks