Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tiered Pull Down Boxes | Excel Discussion (Misc queries) | |||
multi tiered percentage rent calculation | Excel Worksheet Functions | |||
IF then statements-Tiered PRicing | Excel Worksheet Functions | |||
Tiered Calculation | Excel Worksheet Functions | |||
Tiered Pay Scale Calculations | Excel Discussion (Misc queries) |