Log In
Register
Home
New Member
March 25, 2021
Offline
Hello all,
I am trying to calc. the Total Freight from two different sheet with different data.
1. Transport data sheet - contains the item type, zip-codes, weights and prices. Extra condition here is, if the item type is 'Palette', then the minimum weight applicable should be 150kg. And the price is calculated based on the zip-codes and the weights.
2. Toll data sheet: contains distances, weights and prices. Here the toll cost is determined from the weight and distance. there are two extra condition to this:
a) if the shipment type is 'Express' and weight >100kg, add 15% to total toll cost. If it is <100kg, just add 15€ to toll cost.
b) if the goods type is 'Hazardous' add extra 19€ to toll charge.
Total freight cost now should be transport cost + toll cost.
See the file attached.
Kind regards,
Foday.
See Answer
July 16, 2010
Offline
Hi Foday,
Welcome to our forum! There are a few issues with the data in your file, most notably, the numbers are text (weights and freight costs), which is preventing you performing math operations on the data.
In the attached file I've converted the KG and Euro values to numbers. I've used a custom number format to display KG after the weight, but this is only how the number is displayed in the worksheet. If you look in the cell there is no KG entered. This allows Excel to correctly reference and perform logical tests on the weights.
By converting the Euro values to numbers you can then add them to get the Total Cost.
Mynda
Answers Post
1 Guest(s)
