• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Shipping cost with weight & location

sandeep_sarkar

New Member
Hi,

Greetings. Hope you're doing well. If anyone please advice on the following problem -

a) Rate Chart (below)
For Document (till 3 kg) rate will be only single amount, i.e. B3-C9. But for parcels (above 3 kg), the rate will be on 'per kg' basis, i.e. D10-F10.

72113

b) Calculation. I did the calculation manually in column 'Amount' below. But how to do this with excel formula, without any error ?

72114

Thanks for your support. Take care.

Sandeep @ Kolkata
 

vletm

Excel Ninja
sandeep_sarkar
You should reread Forum Rules
Seems that You have skipped many sentences.
 
Top