M
murph-a-mong
I'm writing a spreadsheet to calculate total costs for parcel delivery
I enter a parcel weight in one column of the spreadsheet and wish t
display the parcel's postage cost in another. Below are the weigh
categories for parcel postage
upto 1.0kg = £3.46
upto 1.5kg = £4.45
upto 2.0kg = £4.78
...
upto 10kg = £9.62
etc.
So if I enter a parcel weight of 1.2kg the postage will be £4.45.
However, once 10kg weight has been reached, its an extra £0.86 fo
every extra 0.25kg. so a 10.3kg parcel will cost £11.34 (9.62 + 0.86
0.86)
Any ideas how this could be done?
I've tried to make this as clear as possible but if anything need
clarifying please ask. Thanks in advanc
I enter a parcel weight in one column of the spreadsheet and wish t
display the parcel's postage cost in another. Below are the weigh
categories for parcel postage
upto 1.0kg = £3.46
upto 1.5kg = £4.45
upto 2.0kg = £4.78
...
upto 10kg = £9.62
etc.
So if I enter a parcel weight of 1.2kg the postage will be £4.45.
However, once 10kg weight has been reached, its an extra £0.86 fo
every extra 0.25kg. so a 10.3kg parcel will cost £11.34 (9.62 + 0.86
0.86)
Any ideas how this could be done?
I've tried to make this as clear as possible but if anything need
clarifying please ask. Thanks in advanc