Quote:
Originally Posted by DKTRL
Hi needs some help !!!
I am trying to create a very simple formula to calculate the courier shipping charge. " but i am just a nuts and needs help "
i just want the formula to automatically calculate the shipping cost for me each time when i key in the " weight "
The standard formula to calculate the courier shipping charge are in this way.
1) There is a initial minimum charge. first " 0.1kg to 0.5kg " was charge at the price of $24.80. and thereafter for every addintional 0.5kg will be additional charge $5.80 ( Which mean the charger of 1kg is [$24.80 + $5.80= $30.60 )
Any help will be greatly appreciated!
Thanks !
|
Assuming that the courier is going to charge at .5kg intervals, try this.
actual weight - create cell for actual weight
shipping weight - =ceiling("actual weight",0.5)
Shipping cost - =SUM((("shipping weight"/0.5)-1)*5.8)+24.8
defautt