Excel Postage Calculation Formula
Budget: $10 – $30 AUD
I need an Excel formula to calculate postage charges based on suburb name, postcode, and weight.
Requirements:
- Charges vary by postcode zone and weight
- Weight categories: under 5kg (5 pricing structures based on zones), over 5kg and less than 25kg then
For parcels between 5 and 25kg, base price covers 5kg and per kg starts on the 6th kg.
For example, 8kg would be measured: Base + 3 x (per kg rate).
- Input weight manually for each item
Ideal Skills and Experience:
- Proficient in Excel, particularly with formulas
- Experience with variable pricing based on multiple criteria
Please provide an Excel file with the formula and any necessary instructions for use.
Requirements:
- Charges vary by postcode zone and weight
- Weight categories: under 5kg (5 pricing structures based on zones), over 5kg and less than 25kg then
For parcels between 5 and 25kg, base price covers 5kg and per kg starts on the 6th kg.
For example, 8kg would be measured: Base + 3 x (per kg rate).
- Input weight manually for each item
Ideal Skills and Experience:
- Proficient in Excel, particularly with formulas
- Experience with variable pricing based on multiple criteria
Please provide an Excel file with the formula and any necessary instructions for use.