Different formula for different range based on cell value input

[mpopple6]

Good morning,
I have another complicated issue that I would like to resolve with a simple formula. I work on projects that have a value from anywhere between $200.00 to $10,000,000.00. For my work I have a certain dollar amount that I use based on 8 different ranges that get me different results based on what value I place on the project.

My information is:
Value Fee
1.00 - 500.00 - Initial Fee = 30.00 = This is the end Fee!
501.00 - 2K - Initial Fee = 30.00 for first 500 then 1.25 for each 100 after
2,001.00 - 25K - Initial Fee = 70.00 for first 2K then 5.00 for each 1K after
25,001.00 - 50K - Initial Fee = 400.00 first 25K then 8.00 for each 1K after
50,001.00 - 100K - Initial Fee = 650.00 for first 50K then 7.00 for each 1K after
101,001.00 - 500K - Initial Fee = 1,000.00 for first 100K then 5 for each 1K after
500,001.00 - 1Mil - Initial Fee = 3,200.00 for first 500K then 2.50 for each 1K after
1,000,001.00 - 10Mil - Initial Fee = 5,500.00 for first 1Mil then 1.50 for each 1K after

What I want to do is to type in (or link it to the actual project) the value (let's say 4,003,000.00) and give me the value based on the above information.

I see that I would need to take X (value) minus the amount for the first chunk, divided by the "per unit" and then multiple THAT number by the "fee" AND THEN add the initial fee.

Thoughts on how best to accomplish this in one "catch all" formula?

Thank you so much!!

[crazyforexcel]

I suggest you attach a sample file with expected results.

Thanks

[tim201110]

=(L1-VLOOKUP(L1,$A$1:$C$8,1))*VLOOKUP(L1,$A$1:$C$8,2)+VLOOKUP(L1,$A$1:$C$8,3)
smth is wrong in logic

[6StringJazzer]

This a classic tiered fee problem. This type of problem needs a table. Then you use the table to look up which amounts to apply. See attached. The "Per" value for the first tier is 1 to avoid a divide-by-zero error.

A shows your specs
B:F shows the table based on your specs
H:I shows sample results

The formula is a little complicated but the benefit is that it's trivial to make a change if your fee table changes. You don't have to ever change a formula.