+ Reply to Thread
Results 1 to 3 of 3

Help on calculating a formula for shipping costs

  1. #1
    Registered User
    Join Date
    11-01-2010
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Red face Help on calculating a formula for shipping costs

    On my spreadsheet I need my customers to be able to punch in any weight in the ranges below and be given the price. Up until 70.5 kg I have calculated each weight and priced each service offerred. But from 71kg onwards I need to multiply each price accorrding to the weight ranges. Can anyone, who is much clever than I help me here (I need the formula) as my excel knowledge does not reach this far and Im starting to short circuit.
    IPHW 71 £13.30 £10.40 £4.05 £3.80 £3.35
    IPHW 100 £13.10 £10.25 £4.10 £3.80 £3.35
    IPHW 300 £12.05 £9.45 £3.80 £3.50 £3.30
    IPHW 500 £11.25 £8.75 £3.50 £3.25 £3.25
    IPHW 1000 £10.60 £8.30 £3.35 £3.10 £3.25


    Column One: Means type of parcel
    Coumn 2: Weight
    Column 3 - 7: prices per service


    Regards

    BOTS123
    Last edited by BOTS123; 11-01-2010 at 10:11 AM. Reason: The table seemd to bunch up on view.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,758

    Re: Help on calculating a formula for shipping costs

    Can you give an example? If the weight of the package is 112 kg...or 330 kg what should the price be, how is it calculated from your table?
    Audere est facere

  3. #3
    Registered User
    Join Date
    11-01-2010
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Help on calculating a formula for shipping costs

    112kg Col 3: 1467.2 Column 4: 1148 column 5: 459.20 column 6: 425.60 column 7: 375.20

    330kg Col 3: 3976.50 Column 4: 3118.50 column 5: 1254 column 6: 1155 column 7: 1089


    ALL FINE - Slight panic. Figures are correct
    Last edited by BOTS123; 11-01-2010 at 10:10 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1