Formula Help

[Utradeshow]

Hi Guy's i have this spreadsheet that i need help with. The INPUT cells are F2 and G2.
I need the formula in cell in I2. Would it better to do a macro? for this result?
If Miles 1-400 and G = 1 then 15%
If Miles 1-400 and G = 2 then 8.5%
If miles 401-600 and G = 1 then 20.2%
IF Miles 401-600 and G= 2 then 13%
If Miles 601 > and G = 1 or 2 then 13%
If G = 3 then 0%

BVL Accrual Master.xls
	A	B	C	D	E	F	G	H	I
1	Name	LoadDate	Waybill	COD=1DOD=2CORP=3D&E=4	RatedNetLinehaul	Miles	SelfHaul=1Booker/OA=2HaulerOnly=3	Booking	Bkg%
2								$0.00
3
4			IfMiles1-400andG=1then15%
5			IfMiles1-400andG=2then8.5%
6			Ifmiles401-600andG=1then20.2%
7			IFMiles401-600andG=2then13%
8			IfMiles601>andG=1or2then13%
9			IfG=3then0%
10
Waybill Detail

[/code]

 

[iggydarsa]

try this formula and change the number formating of column I to "percantage":

=IF(AND(F2>=1, F2<=400), IF(G2=1, 15%, IF(G2=2, 8.5%, "")), IF(AND(F2>=401, F2<=600), IF(G2=1, 20.2%, IF(G2=2, 13%, "")), IF(AND(F2>=601, OR(G2=1, G2=2)), 13%, IF(G2=3, 0%, ""))))

 

[barry houdini]

If you create a table with the mileages and possible values for G2 and insert the relevant percentages like below.....

Book1
	A	B	C	D	E	F	G	H	I	J
1	Miles	1	2	3
2	0	15%	8.50%	0%		521	1		20.20%
3	401	20.20%	13%	0%
4	601	13%	13%	0%
5
Sheet3

Formula in I2

=INDEX($B$2:$D$4,MATCH(F2,A$2:A$4),MATCH(G2,B$1:D$1,0))

 

[Utradeshow]

try this formula and change the number formating of column I to "percantage":

=IF(AND(F2>=1, F2<=400), IF(G2=1, 15%, IF(G2=2, 8.5%, "")), IF(AND(F2>=401, F2<=600), IF(G2=1, 20.2%, IF(G2=2, 13%, "")), IF(AND(F2>=601, OR(G2=1, G2=2)), 13%, IF(G2=3, 0%, ""))))

This works GREAT... Thank you SO Much