Yet another just for the fun of it:

=E18*(0,0223*(E181000000)+0,0088*(E185000000)+0, 0179*(E189000000)+0,0075*(E1812000000))

I'd do what JoeU2004 suggests, VLOOKUP, by far the easiest to understand and
maintain when values change in a year or so.

But we are doing percentage of the whole amount: May it be that the result
really should be 0 for the first million, then 2.23 of only anything between
1 and 5 million, and then 3.11 only of anything between 5 and 9 million, and
so on, as in progressive tax?

Best wishes Harald

"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