Forum Discussion

Foday655's avatar
Foday655
Copper Contributor
Mar 25, 2021
Solved

Freight Cost Calc. based on Transport and Toll Cost with some criteria

Excel 2016, OS Windows Hello all, I am trying to calc. the Total Freight from two different sheet with different data.   Transport data sheet - contains the item type, zip-codes, weights and pri...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Mar 25, 2021

    Foday655 

    You switched the row_number and column_number arguments of all INDEX functions.

    And most of your numeric data were actually text values, making it difficult to work with them.

    See the attached version; I have corrected all the errors I could find, but please check carefully,

Foday655's avatar
Foday655
Copper Contributor
Mar 25, 2021

HansVogelaarthank you once more for the help. Everything is working fine except for two things:

1. If Palette is selected, I want to enforce that minimum weight applicable is 150 KG. If Palette is not selected, normal operation applies.

2. When the weight of 600 KG and above is selected, it brings up the '#REF!' message; below 600 KG works fine. 

See the file again.

 

Kind regards,

Foday.

HansVogelaar's avatar
HansVogelaar
MVP
Mar 25, 2021

Foday655 

I had missed one of the switched argument pairs.

I have changed the data validation for the weight for the transport costs - you can now only select the weights appropriate for Not Palette/Palette.

Resources