Layout a bit messed up
So, column A:
0
200.000001
300.000001
1000

Column B:
0.50%
0.75%
2.50%
100%


--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
Put this table in A1:B4

0 0.50%
200.000001 0.75%
300.000001 2.50%
1000 100%


With the sales amount in C1:

=VLOOKUP(C1,$A$1:$B$4,2)

--
Kind regards,

Niek Otten

"Anh" wrote in message
...
For the link Jones gave me, i already had a look..but in my case the
table
showed the upper limit, not lower limit so the approximate match of
Vlookup
did not return the correct answer..
And for the link Max gave me..it's very useful but quite far
complicated...In my case it's not marginal rate...and the answer u
suggested
me seems not work..it keep on turn out to be #VALUE...:(