ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Compute Freight Charge (https://www.excelbanter.com/excel-worksheet-functions/265581-compute-freight-charge.html)

TUNG
Compute Freight Charge
 
Hi, I Would Like To Estimate The Freight Charge.

Freight Charge = Weight X Zone

(the Zone Is Determined By Entering The Destination Zip Code. For Example, If The Shipping Zip Code Is San Jose 95130, The Zone For Destination Morgan Hill 95037 Will Be 3, Zone For A Little Bit Further Salinas Will Be 5).

The Shipping Zip Code Remains The Same. I Would Like A Template To Calculate The Freight By Just Entering The Destination Zip Code & The Weight.
I Will Have A Worksheet With All The Destination Zip Codes And Their Equivalent Zone Numbers.

Please Help. Thanks !!!!!!!!!!!!!

wickedchew
Quote:
Originally Posted by TUNG (Post 959074)
Hi, I Would Like To Estimate The Freight Charge.

Freight Charge = Weight X Zone

(the Zone Is Determined By Entering The Destination Zip Code. For Example, If The Shipping Zip Code Is San Jose 95130, The Zone For Destination Morgan Hill 95037 Will Be 3, Zone For A Little Bit Further Salinas Will Be 5).

The Shipping Zip Code Remains The Same. I Would Like A Template To Calculate The Freight By Just Entering The Destination Zip Code & The Weight.
I Will Have A Worksheet With All The Destination Zip Codes And Their Equivalent Zone Numbers.

Please Help. Thanks !!!!!!!!!!!!!
The VLOOKUP and MATCH functions would be best for your template.


All times are GMT +1. The time now is 05:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com