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).
----------------------------------------------------------------------------------------------------------------------------------------------------------------
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>----------------------------------------------------------------------------------------------------------------------------------------------------------------
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).
----------------------------------------------------------------------------------------------------------------------------------------------------------------
| Retail Price | Dealer Price | Retail Price | Dealer Price | |||
Retail Price | 30310 | $ 986.60 | |||||
Dealer Price | 23867 | $ 1,009.07 | |||||
Your Price | Click to unlock | Correct Taxes total | Difference in tax | 24853.59551 | |||
Taxes and Fees | 2723 | 3494.36 | 2901.604 | -771.36 | 178.604 | 24876.06737 | |
State Tax (4.45%) | 1118 | 1360.81 | 1074.0965 | -242.81 | -43.9035 | ||
County Tax (4.75%) | 1194 | 1452.55 | 1146.5075 | -258.55 | -47.4925 | ||
Lien Fee | 0 | ||||||
Documentation | 200 | 1118 | 25123.59551 | ||||
Temporary Tag | 4 | 1194 | 25146.06737 |
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
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)