Auto Calculate Shipping Weight/Cartons and Package Weight.

**suhailsiddiqui09** · 05-24-2013, 07:13 AM

Hi guys,
Actully I want to creat a function that can exact shipping Weight/Cartons and Package Weight by calculating Web Retail Price between closest ranges.
For example
if Web Retail Price is 32
then Shipping Weight/Cartons should be "3lb 0x0x0in box" and Package Weight should be "3".
Please suggest.

**XOR LX** · 05-24-2013, 08:59 AM

Hi,

For Shipping Weight/Cartons: =INDEX($D$2:$D$125,MATCH(H2,$A$2:$A$125,1),1)

For Package Weight: =INDEX($E$2:$E$125,MATCH(H2,$A$2:$A$125,1),1)

Regards

**suhailsiddiqui09** · 05-24-2013, 11:31 PM

Thank you so much

**etkasper** · 05-26-2013, 11:38 PM

Hello XOR LX,

You seem to know what you doing, are you a professor? :-)

I really need help with the weight prices of products on the attached.

The sheet on column " F " needs to be calculated according to the shipping prices per pound table of Shipping sheet, column B (priority mail), and if column E on sheet products says "Yes" on the Products sheet the insurance amount of Shipping sheet column " " needs to be added as well to the total amount.

The same thing needs to be added for express mail on column " G " of the product sheet, of course, prices have to be according to columns H of the shipping sheet and if "Yes" on column " G " of the Products sheet the insurance amount of Shipping sheet column " J " needs to be added as well to the total amount.

Sorry if I confused you, please let me know if you have any questions.

Thanks in advance for your help on this.

**XOR LX** · 05-27-2013, 06:48 AM

Hi,

First of all, I imagine that one of the administrators of this site will shortly be asking you to begin your own new thread, rather than tagging your question in with this one, so I suggest that you do so and perhaps put a link into this one if you wish.

Secondly, it would be much easier for me to help you if you could re-post your attachment with perhaps two or three different examples in your Products tab where you have manually calculated the total price so that I can tie this in with what you have attempted to explain above.

I will pick it up in the new thread.

No, I'm not a professor!

Regards