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