I am having trouble developing a formula for the following:
in one cell ranges by weight from 1 to 500
501 to 1000
1001 to 2000
2000 >
I need to * this by a rate applicable for each weight and creat the sum for shipping cost.The formula need to select the * based on the weight within the ranges.
Having trouble developing a formula
