Hi Guys, Its been a while since i have been in this forum but I am back for more help from you lovely people seeing as you have always been able to help me with my calculations!
I want to design a spreadsheet that can calculate a price for carriage based on weight. Sounds simple enough however my issue is I have a fixed cost for up to 10kg with a KG price thereafter. So i would like to have a formula that can look at the weight cell and be able to calculate the price given the information.
My example sheet attached shows a parcel of 37kg, I have £8.64 for 10 kg and then 30p per KG thereafter.
I always have the ideas for a spreadsheet to help me in my day to day job but I can never figure out how to formulate the calculations needed.
If anyone can help with this I would be really grateful.
thank you in advance.
Bookmarks