brutalnessities
New Member
- Joined
- Jul 26, 2018
- Messages
- 1
Hello all,
So this is probably a lot easier to solve than i am making it but i need a formula (or VBA) that will solve for the "Dealer Price" (in blue).
----------------------------------------------------------------------------------------------------------------------------------------------------------------
[TABLE="width: 821"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]
[/TD]
[TD][/TD]
[TD]Retail Price[/TD]
[TD]Dealer Price[/TD]
[TD]Retail Price[/TD]
[TD]Dealer Price[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Retail Price[/TD]
[TD]30310[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] $ 986.60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dealer Price[/TD]
[TD]23867[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] $ 1,009.07[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Your Price[/TD]
[TD]Click to unlock[/TD]
[TD="colspan: 2"]Correct Taxes total[/TD]
[TD="colspan: 2"]Difference in tax[/TD]
[TD]24853.59551[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Taxes and Fees[/TD]
[TD]2723[/TD]
[TD]3494.36[/TD]
[TD]2901.604[/TD]
[TD]-771.36[/TD]
[TD]178.604[/TD]
[TD]24876.06737[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]State Tax (4.45%)[/TD]
[TD]1118[/TD]
[TD]1360.81[/TD]
[TD]1074.0965[/TD]
[TD]-242.81[/TD]
[TD]-43.9035[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]County Tax (4.75%)[/TD]
[TD]1194[/TD]
[TD]1452.55[/TD]
[TD]1146.5075[/TD]
[TD]-258.55[/TD]
[TD]-47.4925[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Lien Fee[/TD]
[TD]0[/TD]
[TD="colspan: 2"][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Documentation[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"][/TD]
[TD]1118[/TD]
[TD]25123.59551[/TD]
[/TR]
[TR]
[TD]Temporary Tag[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1194[/TD]
[TD]25146.06737[/TD]
[/TR]
</tbody>[/TABLE]
----------------------------------------------------------------------------------------------------------------------------------------------------------------
In this case the values in green need to be =>red<(red+1) at the same time. Below is what solves for green.
X = 23867 (in this example)
Green: (X+270)*.0445=1074.0965 = A
(X+270)*.0475=1146.5075 = B
=The Blue numbers need to be the solution to lowest value of A and the highest value of B while maintaining both values in red.
(1119>(X+270)*.0445>=1118) at the same time as (1195>(X+270)*.0475>=1194)
So this is probably a lot easier to solve than i am making it but i need a formula (or VBA) that will solve for the "Dealer Price" (in blue).
----------------------------------------------------------------------------------------------------------------------------------------------------------------
[TABLE="width: 821"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]
[/TD]
[TD][/TD]
[TD]Retail Price[/TD]
[TD]Dealer Price[/TD]
[TD]Retail Price[/TD]
[TD]Dealer Price[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Retail Price[/TD]
[TD]30310[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] $ 986.60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dealer Price[/TD]
[TD]23867[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] $ 1,009.07[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Your Price[/TD]
[TD]Click to unlock[/TD]
[TD="colspan: 2"]Correct Taxes total[/TD]
[TD="colspan: 2"]Difference in tax[/TD]
[TD]24853.59551[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Taxes and Fees[/TD]
[TD]2723[/TD]
[TD]3494.36[/TD]
[TD]2901.604[/TD]
[TD]-771.36[/TD]
[TD]178.604[/TD]
[TD]24876.06737[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]State Tax (4.45%)[/TD]
[TD]1118[/TD]
[TD]1360.81[/TD]
[TD]1074.0965[/TD]
[TD]-242.81[/TD]
[TD]-43.9035[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]County Tax (4.75%)[/TD]
[TD]1194[/TD]
[TD]1452.55[/TD]
[TD]1146.5075[/TD]
[TD]-258.55[/TD]
[TD]-47.4925[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Lien Fee[/TD]
[TD]0[/TD]
[TD="colspan: 2"][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Documentation[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"][/TD]
[TD]1118[/TD]
[TD]25123.59551[/TD]
[/TR]
[TR]
[TD]Temporary Tag[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1194[/TD]
[TD]25146.06737[/TD]
[/TR]
</tbody>[/TABLE]
----------------------------------------------------------------------------------------------------------------------------------------------------------------
In this case the values in green need to be =>red<(red+1) at the same time. Below is what solves for green.
X = 23867 (in this example)
Green: (X+270)*.0445=1074.0965 = A
(X+270)*.0475=1146.5075 = B
=The Blue numbers need to be the solution to lowest value of A and the highest value of B while maintaining both values in red.
(1119>(X+270)*.0445>=1118) at the same time as (1195>(X+270)*.0475>=1194)