If VBA Macro for Tiered Calculation
 

Hello,

I urgently need a VBA Macro that will execute the following tiered
calculation:
Total Market Value is cell B1. I need to include the fee in F1

Total Market Value 800,000,000

0.01250 50,000,000 625,000 750,000,000.00
0.00900 100,000,000 900,000 650,000,000.00
0.00750 75,000,000 562,500 575,000,000.00
0.00600 75,000,000 450,000 500,000,000.00
0.00490 50,000,000 245,000 450,000,000.00
0.00480 50,000,000 240,000 400,000,000.00
0.00470 50,000,000 235,000 350,000,000.00
0.00460 50,000,000 230,000 300,000,000.00
0.00450 300,000,000 1,350,000 -



Quarterly Fee 4,837,500

If VBA Macro for Tiered Calculation
 

What are the calculation rules? I see no connection between the Total market
Value (800,000,000) and the Fee (4,837,500)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Jeff" wrote in message
...
Hello,

I urgently need a VBA Macro that will execute the following tiered
calculation:
Total Market Value is cell B1. I need to include the fee in F1

Total Market Value 800,000,000

0.01250 50,000,000 625,000 750,000,000.00
0.00900 100,000,000 900,000 650,000,000.00
0.00750 75,000,000 562,500 575,000,000.00
0.00600 75,000,000 450,000 500,000,000.00
0.00490 50,000,000 245,000 450,000,000.00
0.00480 50,000,000 240,000 400,000,000.00
0.00470 50,000,000 235,000 350,000,000.00
0.00460 50,000,000 230,000 300,000,000.00
0.00450 300,000,000 1,350,000 -



Quarterly Fee 4,837,500

If VBA Macro for Tiered Calculation
 

But for tiered calculations in general, look he

http://www.mcgimpsey.com/excel/variablerate.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message
...
What are the calculation rules? I see no connection between the Total
market Value (800,000,000) and the Fee (4,837,500)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Jeff" wrote in message
...
Hello,

I urgently need a VBA Macro that will execute the following tiered
calculation:
Total Market Value is cell B1. I need to include the fee in F1

Total Market Value 800,000,000

0.01250 50,000,000 625,000 750,000,000.00
0.00900 100,000,000 900,000 650,000,000.00
0.00750 75,000,000 562,500 575,000,000.00
0.00600 75,000,000 450,000 500,000,000.00
0.00490 50,000,000 245,000 450,000,000.00
0.00480 50,000,000 240,000 400,000,000.00
0.00470 50,000,000 235,000 350,000,000.00
0.00460 50,000,000 230,000 300,000,000.00
0.00450 300,000,000 1,350,000 -



Quarterly Fee 4,837,500