=(A1<"")*MIN(A1,4999999)*5%+MAX(0,MIN(A1,9999999)-4999999)*10%+MAX(0,A1-9999999)*15%

You should still tell us how the formula actually works :)

--
** John C **

"KevinM" wrote:

I want to thank you all for the help, but i am not getting the correct
answer back when I try to use you formula. It is double counting
somewhere. I tried the following formula and it will only work for
two out of the three values i try. Is there a limitation for IF
statements?

Value = $15,000,000 - Should return back $1,500,000.15
Value = $ 7,000,000 - Should return back $450,000.05
Value = $3,000,000 - Should return back $150,000

=IF(A1<6000000,(A1*$B$34),IF(A16000000&A1<1000000 0,((A1-6000001)*$B
$35)+(5999999*$B$34),IF(A110000000,((A1-10000002)*$B$36)+(3999999*$B
$35)+(5999999*$B$34),"0")))