Post code calculator
Hi
we send parcels nationwide and i am trying to get a spreadsheet set up which will automatically calculate the costings.
Ideally, i want anyone to be able to type in the post code and weight of an item, and it will calculate the cost.
i have attached an example spreadsheet.
any help would be great
Last edited by AliGW; 08-10-2021 at 07:25 AM. Reason: Urgency removed from post.
Which version of Excel are you using? Please update your profile.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
In what format will post codes appear? You don't seem to have mocked anything up to show how you want this to work.
I think you need to explain a bit more
1) how are you entering the postcode, is it a full postcode or just the letter prefix?
2) do the values in e3:m3 need adding and if yes what is the trigger for this? Do they match with the postcode areas?
3) if you wish to add the values in column B it would be much simpler if they were just the value as a number
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks