Cost formula

[fireslguk]

I have 20 costs against certain areas

Example 0 to 1250 area is 0.46
1251 to 2500 is 0.60
2501 to 3750 Is 0.72
3751 to 5000 is 0.87

So on and so on up to 20 rows

How can I have 1 cell produce the cost dependant on the value of another

 

[alansidman]

Book5
	A	B	C	D	E
1	750	0.46		0	0.46
2	2751	0.72		1251	0.6
3	3752	0.87		2501	0.72
4	4753	0.87		3751	0.87
5	1754	0.6
6	2755	0.72
7	3756	0.87
8	4757	0.87
9	1758	0.6
10	3759	0.87
Sheet1

Cell Formulas
Range	Formula
B1:B10	B1	=VLOOKUP(A1,D$1:E$5,2,TRUE)

 

[fireslguk]

Book5
	A	B	C	D	E
1	750	0.46		0	0.46
2	2751	0.72		1251	0.6
3	3752	0.87		2501	0.72
4	4753	0.87		3751	0.87
5	1754	0.6
6	2755	0.72
7	3756	0.87
8	4757	0.87
9	1758	0.6
10	3759	0.87
Sheet1

Cell Formulas
Range	Formula
B1:B10	B1	=VLOOKUP(A1,D$1:E$5,2,TRUE)

Perfect thankyou