Forum Discussion
Solved
Help please with a shipping cost calculator.
Hello,
Would someone kindly help with calculating shipping costs in excel. I have tried the 'IF' function however I need excel to choose between five costs but for packages that range in size from 3cm x 30cm up to 200cm x 120cm.
I thought that if I have two cells to enter height and width, to give area then the result could be compared or measured say up to one cost, then up to a second cost then up to a third cost and so on, but my excel knowledge is not that
=INDEX($F$3:$J$6,MATCH($C$2,$E$3:$E$6,0),MATCH($C$3,$F$2:$J$2,0))An alternative to a nested IF formula could be a reference table and an INDEX and MATCH formula.
2 Replies
=INDEX($F$3:$J$6,MATCH($C$2,$E$3:$E$6,0),MATCH($C$3,$F$2:$J$2,0))An alternative to a nested IF formula could be a reference table and an INDEX and MATCH formula.
