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 3...
=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.
