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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
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