hi
I am new to this. I tried the following formula for the pricelist but could not get it to work.
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
the pricelist I am working from is:
R25 plus per kg price.
for a 2 kg parcel it would be R25 plus R3 per kilo which would be R31 total.
for a 3-5 kg parcel it would be R25 plus R4 per kilo.
as the kg's increase the price per kg decrease.
Is there someone the could help with a formular to calculate the total amount payable?
Thanks in advance.
Kind Regards
Bookmarks