| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Needs Help "calculate of courier service charge"
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 ! |
|
#2
|
|||
|
|||
Quote:
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 |
|
#3
|
|||
|
|||
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | Excel Discussion (Misc queries) | |||
| Add a service charge | Setting up and Configuration of Excel | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
| Excel Service error "cannot connect to external data source" | Excel Discussion (Misc queries) | |||
Linear Mode
