Hello All
Im fairly new to big formulations in excel
im trying to make a Freight Calculator
Where you will enter the Region(B1:F1) to a cell B11 and weight(A2:A7) into Cell B12 and it will return the rate(B2:F7) to Cell B13 multiplied by the weight
i work out how to do it with entering the Exact weight listed but if the weight is different it would return an error
so it need to find the rate between a certain range? im not sure if this makes sense
( See attached )
thanks for your help
Bookmarks