help need to calculate shipping cost for each products

[laskoibence]

hi all,

I need some expert help please:

I have an excell spredsheet of about 100 products which I am selling. I have the weights of these products in D10-D108, in gramms, I would like to use a formula to calculate the shippping cost for each of these products. I input the shipping cost into K1-K5 and the weight allowance to J1-J5. Like J1 1000 (max weight) K1 2.99 (cost for max 1000 g weight).Thanks in advance.

 

[laskoibence]

tried this but no luck:

=IF(D10<=J1,K1,IF(D10<=J2,K2,IF(D10<=J3,K3,IF(D10<=J4,K4,K5))))

 

[kweaver]

Please use XL2BB to illustrate some of your spreadsheet data and expected results.

 

[kweaver]

Maybe you're looking for something like this? The weights in J are the lower limit of each bracket.

051923 Sum Spreadsheet.xlsm
	E	F	G	H	I	J	K
1						0	0.75
2						1000	1.00
3						1200	1.50
4						1500	2.00
5						2000	2.99
6
7
8
9	Weight	Cost
10	300	0.75
11	1200	1.50
12	50	0.75
13	250	0.75
14	1100	1.00
15	1600	2.00
16	2000	2.99
17	3000	2.99
18	1000	1.00
Sheet2

Cell Formulas
Range	Formula
F10:F18	F10	=VLOOKUP(E10,$J$1:$K$5,2,TRUE)