Results 1 to 4 of 4

I Need a little help with Formula to calculate weight etc.

Threaded View

  1. #1
    Registered User
    Join Date
    08-11-2019
    Location
    London
    MS-Off Ver
    11
    Posts
    29

    I Need a little help with Formula to calculate weight etc.

    Hi everyone I am back again.
    I have come a bit stuck again.

    I have recently added iferror statement to my table but it is not working as i expected.
    I am trying to Create a Value for Item names and add weight to the item then calculate aditional weight like envelope etc.
    then to inform me what envelope size to use and then calculate recently added (So i can update) postage fees.

    The complications i had where with the weight and size. If the weight was over 750g then the tarriff would be "Parcel".
    I have setup the limits of how many items each envelope can handle to stay within the Large Letter size (UK Postage Tarriff) as the next step is "Parcel"

    Two criteria occur.
    If it is over 750g then it is a Parcel
    If it is thicker than 25mm then it becomes a Parcel Ref Envelope Size F3B, P1A-P1D (I made these up myself)
    Everything else that is 750g or below and under 25mm then it is: Ref Envelope Size A000, C0, E2, F3 (Official Sizes)

    When it is larger that F3 then i stack upto 5 x F3 and assemble as a single package. F3B is a double thick single package F3 making Parcel Size.

    I have added my Workbook if anyone would like to guide me in the right direction.
    I have tried to make it as clear as possible but i know i could probably do better.
    Last edited by carl97; 09-07-2019 at 10:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need a formula to calculate the (imperial) weight of steel plate
    By spencergraves13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-23-2023, 07:04 PM
  2. Formula to automatically calculate weight loss over separate dates.
    By kellerman1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2019, 08:35 AM
  3. Calculate weight
    By Getfothers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2017, 09:47 AM
  4. formula to calculate freight rates by zone weight - weights are incramental
    By Pause550 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2016, 12:42 AM
  5. [SOLVED] How to calculate total weight
    By Shi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-22-2013, 06:49 AM
  6. Auto Calculate Shipping Weight/Cartons and Package Weight.
    By suhailsiddiqui09 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2013, 06:48 AM
  7. calculate charge from weight
    By Nahc in forum Excel General
    Replies: 4
    Last Post: 03-01-2008, 01:00 PM

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