"bigproblem" wrote:
if e18 is more than 1,000,001 and less than 5,000,000 i want
to mulitple e18 by 2.23.

First, I assume you mean "more than 1,000,000" or "not less than 1,000,001".
That is the typical interpretation of such tables.

Second, I assume you mean "multiply by 2.23%", or at least the number you
have in column B.

Start by reorganizing the table so that column A is simply the lower limit.
Then:

=E18*vlookup(E18,$A$1:$B$5,2)

If you truly want "more than 1,000,001" (e.g. 1,000,001.01 and more), change
the lower limit to 1000001.01, and use VLOOKUP(ROUND(E18,2),...).


----- original message -----

"bigproblem" wrote in message
...
i have a table -

column a column b
$0 - $1,000,000 0.00%
$1,000,001 - $5,000,000 2.23%
$5,000,001 - $9,000,000 3.11%
$9,000,001 - $12,000,000 4.49%
$12,000,001 and above 5.65%

if e18 is more than 1,000,001 and less than 5,000,000 i want to mulitple
e18
by 2.23. if e18 is more than 5,000,001 and less than 9,000,000 i want to
mulitple e18 by 3.11. if e18 is more than 9,000,001 and less than
12,000,000
i want to mulitple e18 by 4.49. same if e18 is above 12,000,0001.

How do i do that ?




--
problem