Forum Discussion
Weight cost formula
I need help to create a formula that must spit out a price after taking weight into consideration.
I don't know how to produce this formula and would appreciate some help.
I attach the file and you can see what is needed. Can some good expert help with this?
SergeiBaklanmaybe 🙂
From my point of view Riny_van_Eekelen gave right solution, it's better to keep transportation fee depends on weight in helper cells. From maintenance point of view that's much easier, any correction could be done in one place only, not in each formula.
But if you what to hardcode it that could be like
=D14+LOOKUP(B14,{0,1000,2000,3000,4200,15000,19000,40000,60000},{22.5,41.25,41.25,42.5,45.75,46.5,71.5,85.5,85.5})or, if to use only your range
=D15+LOOKUP(B15,--LEFT($F$4:$F$12,SEARCH("-",$F$4:$F$12)-1),$E$4:$E$12)where the weight is in B14 or B15.
Both are in attached.
8 Replies
Hello Riny_van_Eekelen
No this doesn't answer the question. I need a formula that should be in the Total selling price column and take the transport fee and weight into consideration. Like C4 = D4+E4(transport fee) when weight is 1-1000.
C5 = D5+E5(transport fee) when weight is 1000-2000 and so on...
How can this be done???
Sorry, but I don't get it. Assuming you don't just want to enter =D4+E4 in cell C4. Thought you wanted to calculate the total price as 10 plus the transportation cost depending on the weight. That would make perfect sense.
Could you otherwise indicate what outcome you want to see in numbers. Then. I'm sure we can create a formula for you.
