Long IF string?

[mittmje]

What would the formula be for the following:
if column A is:
>0 column B would be 10%
>18551 column B would be 15%
>73301 column B would be 25%
>151901 column B would be 28%
>231451 column B would be 33%
>413351 column B would be 35%
>466951 column B would be 39.6%

Thank You

[AliGW]

Best way is to create a lookup table and use VLOOKUP.

[mittmje]

Thanks, would you please provide the formula
Thanks

[mittmje]

I created the table, but am having trouble with the formula. Please see attached example
Thanks

[FlameRetired]

I removed the leading ">" from the lookup table.

In C2 and filled down this formula.

Please Login or Register  to view this content.

	B	C	D	E	F	G
1	Amount	Appropriate column G # from the table			Table array
2	19000	0.15			0	0.1
3	75000	0.25			18551	0.15
4	250000	0.33			73301	0.25
5	300000	0.33			151901	0.28
6	420000	0.35			231451	0.33
7					413351	0.35
8					466951	0.396

[FlameRetired]

Duplicate post.

http://www.excelforum.com/excel-new-...2-vlookup.html