need help finding a formula

[akiwal]

Hi,
I need help finding a formula to put into column G, to figure out the prices per item, as the price depends on the quantity in column F. look in row 5 where it's stated the different quantity's amounts.
of course, I can do four times the if formula, but I want to know if there is any shorter formula.
Thank you

help2.xlsx
	A	B	C	D	E	F	G	H	I
1
2
3	Wholesale Stationery Supplies
4	Item	Unit price for quantities less than or equal to:				Quantity ordered	Price per item	Quantity x Price
5		10	20	50	100
6	Pencil	0.3	0.25	0.19	0.14	43
7	Ball Pen	1.23	1.12	0.98	0.67	50
8	Eraser	0.23	0.17	0.14	0.12	9
9	Paper Clips(box)	1.76	1.56	1.17	0.99	20
10	Drawing Pins	1.89	1.76	1.54	1.23	46
11	Pencil Sharpener	3.67	3.54	3	2.12	44
12	Refill A4 Lined	8.56	6.89	5.67	5	99
13	Ream A4 Photocopy	7.66	7	6.54	5.12	27
14	Ruler	1.34	1.13	1	0.77	47
15	Compass	2.56	2.44	2.1	0.89	97
16	Protractor	0.98	0.78	0.56	0.39	6
17	Sellotape	4.34	3.56	2.34	1.47	15
18
19							Total
20
21
22
Sheet1

 

[AhoyNC]

Try

Book3
	A	B	C	D	E	F	G	H
1
2
3	Wholesale Stationery Supplies
4	Item	Unit price for quantities less than or equal to:				Quantity ordered	Price per item	Quantity x Price
5		10	20	50	100
6	Pencil	0.3	0.25	0.19	0.14	43	0.25	10.75
7	Ball Pen	1.23	1.12	0.98	0.67	50	0.98	49.00
8	Eraser	0.23	0.17	0.14	0.12	9	0.23	2.07
9	Paper Clips(box)	1.76	1.56	1.17	0.99	20	1.56	31.20
10	Drawing Pins	1.89	1.76	1.54	1.23	46	1.76	80.96
11	Pencil Sharpener	3.67	3.54	3	2.12	44	3.54	155.76
12	Refill A4 Lined	8.56	6.89	5.67	5	99	5.67	561.33
13	Ream A4 Photocopy	7.66	7	6.54	5.12	27	7.00	189.00
14	Ruler	1.34	1.13	1	0.77	47	1.13	53.11
15	Compass	2.56	2.44	2.1	0.89	97	2.10	203.70
16	Protractor	0.98	0.78	0.56	0.39	6	0.98	5.88
17	Sellotape	4.34	3.56	2.34	1.47	15	4.34	65.10
18
19							Total	1,407.86
Sheet1

Cell Formulas
Range	Formula
G6:G17	G6	=XLOOKUP(F6,$B$5:$E$5,B6:E6,B6,-1)
H6:H17	H6	=F6*G6
H19	H19	=SUM(H6:H17)